Background: Hi! I have built a very big reporting and forecasting tool
that has over 30 worksheets tht link and roll into each other.

The report is HUGE and we have no central repository to share this tool
plus only a couploe of people need to actually use the tool to
forecast. Mainly, we want people to see the end results.
Question:Is there a way to export the values of each sheet (30 of them)
at one time into an empty shell of a different work book so we can use
that one to distribute?

So basiclaly, I am looking to write a macro to export the value and
formats (no formulas) of many sheets into a new workbook without having
to copy and paste one sheet at a time.

thanks for your amazing help!
Tina