Move (list) data from one Excel 2010 tab to a new summary tab

Closed
Report
Posts
1
Registration date
Tuesday September 9, 2014
Status
Member
Last seen
September 9, 2014
-
Hello,

Would someone be able to advise if there's an automatic way of moving data from multiple Excel 2010 tabs onto a summary tab please?

I work in a dept with 8 employees, we each have a tab in the spreadsheet so it can be a shared file. We need all the data moved onto one summary tab aswell. Is there an automatic way of doing this as opposed to copying and pasting?

My aim is to get all the data onto one tab, so we can make a create a pivot table with the data. I have tried consolidating pivot tables, but half the data is removed.

Thank you.