Excel Summary sheet

Hi All,

I am urgently trying to find out how you would set up a automated update from 6 tabs within a spreadsheet to one summary tab. The data has uniques refs for each line but the data is dates and not calculations. the 6 workstream tabs are updated daily and then I have to cut and past all the info over to the summary sheet on a daily basis.

I have tried special paste but this does not update if an new line is added out of the original chosen rows.

Has anyone got any ideas? ? ?

Pulling hair out as i speak ,, Amanda 🙁