Multiple sheet copy and paste problem

Copper Contributor

Hello Everyone,
I've came here looking for help to solve an issue I'm facing..
I have multiple sheets and I want to copy different cells and paste them in a summary sheet.
How can copy " total operation revenue " from each factory sheet to the summary sheet, and same goes " other operation" , operation expenses and so on, without me going back and forth between those sheets.

Please find the attached file for a clean picture of my issue 

Thanks, Sami

1 Reply

@Sami86 Look into using the INDIRECT function as demonstrated in the attached file. I suspect, though, that your real life situation may more complex than your example sheet. And then there are probably better ways to summarize the data. But for now, I'm just answering you question.