Compile Data In Excel Files

We have several excel files from a furniture manufacturer. We need all the information compiled into 1 master spreadsheet because we plan to import everything into a website to sell online. The files list all their furniture. We want ONLY the items listed under the "Bedroom" category in each spreadsheet. (ignore entertainment, dining, organizational, sections etc.) Each spreadsheet represents a product series. Products are grouped by sets. For example, each furniture set may contain 3 or 4 products. We want 1 comprehensive table with all the individual items from each set and another table to list each set. We've created a screenshot of a sample spreadsheet and how the data should be complied. We've also attached a .zip with all the product spreadsheets and a .zip with 2 sample tables of how we want the data compiled. ## Deliverables Data from all spreadsheets must be compiled in the format in the example tables. See attached picture describing what needs to be done. Files have been attached as well for you to evaluate.