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