linking worksheets to one tab

[joncheal]

Hi,

I am trying to create a work book that links all of the tabs onto one worksheet. Ideally what i want to be able to do is by using a report filter populate the data for that specified criteria which is located on one of the other tabs. The data across all of the tabs is the same they will just have a different values next to them. I have currently got it set up using a pivot table that collates all of the sheets together by my problem with this is it will only allow me to name 4 "items"within the pivot where as i have 10 worksheets feeding into it so the rest just show as Item1, Item2 etc. So what i am trying to ascertain is whether there is any other way other than using a pivot table to give me the results i am looking for.

Any help on this would be greatly appreciated

 

[Jerry Sullivan]

Hi Jon,

Is your PivotTable using a data source of "Consolidation" type? I don't use that function because the resulting Pivot Tables have some restrictions.

One alternative is to use SQL to consolidate the data from multiple sheets. This link has some instructions...

http://www.mrexcel.com/forum/excel-...orksheets-referencing-1-main-pivot-table.html