Microsoft Excel data transfer from tables

we have Approx 20 spreadsheets of data, some with one table and others with several, that we need to extract into an easier to read columned spreadsheet. Many products we sell have several different configurations, so the vendor has put the price sheet in a table instead of listing them individually in a column. We need to get them out of the table and into a column to enter them in our system. There is a pdf catalog online where you can see exactly how each product should look and would be ordered so taking the individual parts out of the tables and putting them into the columns would be easier.