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

  • Thread starter Thread starter Phippsy
  • Start date Start date
P

Phippsy

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
 
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
 
Back
Top