I can't use Scenarios for the following task because it takes about a minute
to do the Summary on Scenarios and it sometimes crashes Excel. So, I am
seeking an alternative:

I have a multi-tabbed workbook where I want to have key cells from each tab
copied to a separate row on a Summary tab.

Each tab follows the same template.

1. Is there a way to make one of the tabs a blank template so that every
time I want to create a new tab to fill in the information, the template is
easily transferred (including column widths, etc.) to the new tab. I suppose
I can copy and paste from the template tab to the new tab, but I 'm wondering
if there is something more streamlined to do this.

2. On the Summary tab, I laboriously put cell references from Sheet 1! into
the appropriate cells. The information from the next tab will start on the
next row on the Summary down from the information from the existing tab, and
so on. If I copy and paste the existing rows to the new rows, the references
will still refer to Sheet 1 and will have the relative locations thrown off.
Is there a way to copy the existing rows to the new rows and make a blanket
change from Sheet 1! to Sheet 2! Also, to keep the same absolute cell
references to apply to Sheet 2!

With regard to the latter, I know I can laboriously hit F4 to put $ next to
each cell reference before I copy the formula, but this is time consuming.
Is there a way to change Sheet 1! to Sheet2! on a blanket basis and also
insert the $ on a blanket basis to the references are made absolute all at
once.

Also, if my idea of tabbed woksheet connected to a summay tab is not
optimal, I certainly would appreciate suggestions as to a more user-friendly
way of accomplishing my task without using Scenarios, which is not working
well in this instance.

More rather than less detail is appreciated, because I am no more than an
intermediate Excel user, not advanced.

Thank you.