Data gathering from multiple sheets in a workbook

[aspar165]

I am trying gather data into a cover page from multiple sheets in a workbook. The sheets are all formatted the same but have unique names and multiple criteria that I'd like to organize on a cover page. The number of sheets in the workbook will also vary from month to month.

Each sheet has the following criteria which I need to organize:

• Department (6 total)
• Class of product (7 total - 100, 200, 300, etc)
• Cost of product
• Retail Price of product
• Quantity of product

In the end, I will need to associate the Class, Cost and Retail Price to an account number.

I know I can build a macro to do all of this but I'm not sure where to start and want to see some different ideas of what I can do.

Thank you!

 

[jmthompson]

It would help if you could post a sample of your data, or mock-up's of your data. A sample of a source sheet and a sample of the desired summary sheet.

 

[aspar165]

I have a file with vital info removed. You can see all the data sheets that I need to extract from. Can I email it to you?

 

[jmthompson]

I don't think I will have time to look at it. If you search the thread for the MrExcel html maker add-in, you can post a sample on the board for any available person to help with