I am using a pretty simple spreadsheet. One worksheet (estimate 1)
calculates a job cost by multiplying hours x labor rates. There are some
text boxes where I can enter notes etc. In a separate sheet (summary) I
summarize all the data from "estimate 1" by setting cells in "summary" = to
specific cells in "estimate 1"

A very simple transfer of data.... First Column is the Categories/Headings
and 2nd column is the data from "estimate 1"

Often, we are asked to estimate several jobs for the same client. To do
this, I make as many copies of "estimate1" (before I add data) as I need for
the number of projects we are estimating and name them "estimate 2, estimate
3 etc...."

What I would like to see happen is that for each copy of "estimate 1", I
would like a corresponding column to summarize the data in the sheet
"Summary".

Any ideas?