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

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Protection 0
Query the same table three times 0
Cell data entering slow! 0
Found few bugs in my daily routine of work in excel for MAC 0
If/Then/Else Query 6
summarize data from one spreadsheet to other spreadsheet 10
Found few bugs in my daily routine of work in excel for MAC 0
Copy Data from One sheet to Different Sheets 1

Top