Hello,

I am using EXCEL 2013 and am attempting to consolidate data from a specific worksheet in 10 different worksheets.

I know how to create table sand create a pivot table from these tables when they are in the one worksheet but was wondering if anybody knew a way of getting the data from the other worksheets into the one workbook initially (or a better way altogether!)

My VBA is limited although I am unsure whether this is necessary here. I know that previous versions of excel had a multiple consolidation tab the pivot table wizard though I never used it. The Excel 2013 does not seem to have this option.

Any help would be much appreciated!