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