I don't know the details of your data, but I bet it would be much simpler if all
the raw data was on a single sheet.

Add an indicator field (essentially an indicator that would have told you what
sheet that data would be on) to each row. And one logical record per row--don't
split your logical data over multiple rows.

Then you'll be able to make charts, use autofilter, sort the data, and even
create pivottables.

Spreading the raw data over 50 different sheets sounds very bad to me.

If the data won't fit on a single sheet, then maybe excel isn't the application
you should be using--maybe a real database program would be a better suit
(Access????).

MKSG_puzzled wrote:

I have the first page of my workbook as my summary page. I then have 50
other worksheets that have individual data on them. How do I create a
template (if you can) for the worksheets to tie their data into the main
summary page. For example: I want to publish the following example data from
each of the worksheets to the summary page:

Project #
Project Name
Contract Amount
Location

--

Dave Peterson