Venturing 2 options for you on your 2nd Q

Option a:
Consider a re-design of your summary sheet. Have an "easier-to-propagate"
lay out where the sheetnames are listed in say, B2 down, and the cell
references in C1 across

Eg you could have in B2 down, the sheetnames:
GM
Ford

And in C1 across, you'd have cell refs eg:
A5, A8, B14, A7, C4, E2

Then you could place in the top left intersection cell, ie in C2:
=INDIRECT("'"&$B2&"'!"&C$1)
and simply C2 copy across/fill down as far as required to populate the summary

Option b:
As-is, to propagate the formulas from the 1st to the 2nd block, you could
try EditReplace, along this sequence:

Neutralize the formulas in the 1st block, then copy n paste, then replace
sheetnames in the pasted range, then restore all formulas in both destination
and source

1. Select source "GM" range of formulas, replace "=" with say "zzzzzzz"
2. Do the copy paste
3. In the pasted selection change the sheetnames enbloc from "GM" to "Ford"
with an EditReplace
4. Then restore the "=" with a reverse: Replace "zzzzzzz" with "="
in both pasted range & in the source 1st block
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
---
"Tenacity9" wrote:
.. For eg, two rows on the Summary I want to copy have the following
references reading columns from left to right:

GM!A5 GM!A8 GM!B14
GM!A7 GM!C4 GM!E2
etc.

I want to copy these references a few rows down to automatically paste these
references:

FORD!A5 FORD!A8 FORD!B14
FORD!A7 FORD!C4 FORD!E2
etc.