Populate cells on multiple sheets based on list

I am having a hard time searching for this formula because I can't explain it very well, but it's giving me fits.

Sheet1 has the following data in A1:A5

value1
value2
value3
value4
value5

I then have 5 additional sheets
I want to populate cell D2 on each additional sheet with the values from Sheet1

Sheet2 - Value1 in "D2"
Sheet3 - Value2 in "d2"

and so on...

any help appreciated

Hi,

By the looks of it, you just need to reference the cells on Sheet 1 - like so:

In Sheet2, D2 enter:

=Sheet1!A1

In Sheet3, D2 enter

=Sheet1!A2

And so fourth...
Is that what you were after?

Thanks greg for the quick reply. Thats what I want, but of course it's not that easy. I have 400+ sheets and 400+ values that need entered on those sheets. Looking for a formula that I can copy paste to the sheets that will pull the next one off the list in sheet one and paste in cell D2 of each sheet in order.

Ok, I've played with it for a few hours (still no luck). I think I can explain what I actually need a little better.

Sheet 1 has a list of names (A1:A400)

Sheet2:Sheet401 are data sheets with Cell D2 in each needing a name from the list in sheet 1

So 'sheeet2'!d2 will = 'sheet1'A1
'sheet3!d2 = 'sheet1'A2
'sheet4!d2 = 'sheet1'A3

and so on... just want to copy paste across all sheets and have it fill in D2 on each sheet with the next value from the range on sheet1's list.

Hi,

Sorry for no reply, been busy with weekend.
I'm pretty sure you'll need to do this with VBA. It won't be complicated, and the code should be able to insert all the sheets for you, as well as input the data from sheet1...

Unfortunately - VBA isn't really my area, for now at least. I'd recommend re-posting this in the VBA section with a very clear explanation of what you need.