Copy/paste data from different work sheets to master sheet

**Guckmall** · 06-03-2013, 07:43 AM

Hi everyone

I am working with a document containing a more than 20 worksheets and I want to get an overview in a master sheet containing key figures. As time goes by, I will also be in need of adding new worksheets and these should also be possible to view in the master sheet.

I have so far been copy/pasting manually everytime I had to update with a new sheet, but this is quite time consuming and I am sure there is a more effective approach to this task.

I have attached a copy of the master sheet and one data sheet. The original document contians a lot more, but this captures the main challenge.

Hope someone have a solution.

Best regards

Sebastian

**arlu1201** · 06-03-2013, 07:50 AM

If you need to add new data to the individual sheets, do you add it to the next available row of the individual sheets?

**Guckmall** · 06-03-2013, 07:57 AM

The individual sheets contain a more or less fixed amount of data. New data will be added through a new sheet being made.

Hope this answers your question.

**arlu1201** · 06-03-2013, 08:02 AM

So you wouldnt need to add new data to the already existing sheets, right?

The reason i am asking you this - if you add new data to the existing sheets, the summary sheet will need to be cleared and reloaded with data from rows 2 to the last row of each sheet. This is done to avoid duplicates in the summary sheet, each time new data is added to the individual sheets.