Dec 21 2022 07:44 AM
I am trying to add the same cell from five previous sheet to the same cell on a summary sheet
Dec 21 2022 07:55 AM
=CONCATENATE(Table1!A1,Table2!A1,Table3!A1,Table4!A1,Table5!A1)
You can enter this formula in cell A1 of the summary sheet and then fill it across range A1:Z1000 for example.