Combining specific data from multiple worksheets

[shaun86]

Is it possible to combine specific data from multiple worksheets? I have worksheets different people fill in so they're all identical as far as structure. I'm assuming this is more than just a simple formula.

Secondary question can specific data be pulled from other sheets? For example I have a list of inventory numbers but I only want ones that start with "GMP" pulled to a separate sheet.

 

[shaun86]

I have multiple sheets filled out by others but I want a master sheet that when I open it combines all the information or a designated portion of it onto that one that's current.