I need to create a summary sheet where I add the same cell from 5 previous sheets to a summarized

Copper Contributor

I am trying to add the same cell from five previous sheet to the same cell on a summary sheet


1 Reply




You can enter this formula in cell A1 of the summary sheet and then fill it across range A1:Z1000 for example.