Enter data from same cell in different sheets into a new sheet
 

I Have for example text in A1 on 4 sheets.
I want to have all that data on a new sheet either in a column or row.
For example
Sheet 1 A1 says date1
Sheet 2 A1 says date2
Sheet 3 A1 says date3
Sheet 4 A1 says date4

New sheet wahts to show Date1 date2 date3 date4

Thanks

Enter data from same cell in different sheets into a new sheet
 

=INDIRECT("'Sheet "&COLUMN()&"'!A1") and copy across
--
David Biddulph

"Phippsy" wrote in message
...
I Have for example text in A1 on 4 sheets.
I want to have all that data on a new sheet either in a column or row.
For example
Sheet 1 A1 says date1
Sheet 2 A1 says date2
Sheet 3 A1 says date3
Sheet 4 A1 says date4

New sheet wahts to show Date1 date2 date3 date4

Thanks

Enter data from same cell in different sheets into a new sheet
 

Apply the below formula and copy down to 3 cells

=INDIRECT("'Sheet"&ROW(A1)&"'!A1")

OR

'if there is a space between Sheet and the numeric part like 'Sheet 1'
=INDIRECT("'Sheet "&ROW(A1)&"'!A1")

If this post helps click Yes
---------------
Jacob Skaria


"Phippsy" wrote:

I Have for example text in A1 on 4 sheets.
I want to have all that data on a new sheet either in a column or row.
For example
Sheet 1 A1 says date1
Sheet 2 A1 says date2
Sheet 3 A1 says date3
Sheet 4 A1 says date4

New sheet wahts to show Date1 date2 date3 date4

Thanks