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

summarize data from one spreadsheet to other spreadsheet 10
Finding MIN value in a column between Two Dates in different columns 3
Lists with dates in them 2
Value in Crosstab Query 1
2 Criteria Summing 3
vlook up two column 4
A simple query problem 5
Progressive number in different sheets 7

Top