Consolidating data from multiple worksheets

Hi,

I have a workbook that has several different worksheets. Each worksheet is a region and has same headlines. In the sample file attached, the production # field is unique number. I would like to have a summary table that would allow to user to find a production code for each item by filtering region, section, type and endorsement number. I was thinking of using pivot table consolidating ranges but it didn't give me the right result. Could anyone have any idea how to do it?

Many thanks in advance!
Ann

Originally Posted by K m

See the attached worksheet

Hi,

I'm looking for something cleaner and more user friendly since the actual data I have is massive with more than 10 different spreadsheets and more headlines. Is there any way to have a form/table that extracts data from separate spreadsheets? For example, it would show only unique items under each of the headlines instead of combining them all in one

Thanks a lot,
Ann