Transform an excel database into a dynamic price list for printing

I have an excel spreadsheet that consists of 106 sheets Each sheet is exactly the same and contains pricing data derived from formulas to give a product selling price for quantity breaks and other options. Also there is information on shipping costs and weights etc.

The task is to write something that pulls the necessary information from each sheet and display it in single multi page price list format for our distributors to work from.

Since prices etc do change month to month it will be necessary to easily update the price list from the original excel file and add new lines as they are added to the product pricing list. This all could be done by cutting and pasting but it would be laborious and prone to errors. I think something like a look up table would do it