Forum Discussion
I need to create a summary sheet where I add the same cell from 5 previous sheets to a summarized
I am trying to add the same cell from five previous sheet to the same cell on a summary sheet
=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.