I have a workbook with 10 sheets.

Sheets 1-5 contain a cost model for a single state. Sheets 5-10 contain
input data to the cost model for 35 different states. Sheets 1-5 have lookup
functions, etc. that access the correct input data in sheets 5-10 based on
the value in a cell, say "state".

What I ultimately want is 35 different workbooks, one for each state. None
of the 35 should have sheets 5-10 (I'll have to do copy, paste values).
Also, none of the 35 should have any macros or named ranges.

What's the best way to do this? I know how to do most of it I think. What
I'm struggling with is...if I delete all sheets 5-10 and save it as "Texas",
then how do I get the original workbook with all of the formatting and
references back? I'm sure there's an elegant way to do this.