How do I create a master List?

[LotusMan333]

I have an excel file with all our companys parts in it. However these parts are divided into sheets by company. The name of each company is the sheet name, and then the parts with their information are listed under each sheet.
Is there anyway that I can get all of that information on a single sheet, with the company name by all the parts in an efficient way. Thank you

[keithfender]

In your one sheet, add a column for "Company Name." That way you get all of them on one sheet. This also makes it easier to show data with pivot tables if everything is on just the one sheet.