Copying the same data across multiple sheets

[kendrawithpets]

Hello,

I have the same data repeated across several sheets.

Example: In Sheet 1 which I named Risk Review in cell A3 I have 'Analyst Name' and then in B3, text should be entered. In Sheet 2 (renamed Walkthrough) I have 'Analyst Name' in A6, and then text should be entered in B6. What I'm trying to do is populate Sheet 2 with Sheet 1's information. I used the formula:

=Sheet1!B3 but it seemed to just give me #REF! And when I entered the name into B3 on Sheet 1 it didn't populate as it should. Not sure what else I need to do?

I'm in Excel 2010.

 

[mole999]

go to you second sheet, type = then point to the sheet you want the data from, I'm thinking its a sheet1 / risk review issue