Dave Peterson wrote

That's the way the code was written--using row 1 as headers and data
starting in row 2.

Did you have trouble when you tried it?

That's what it looked like to me, looking at the various .Cell references.
For some reason, A2 & F2 on Sheet2 wind up with a 0 (zero) in them. Could
it be because I have an equal number of rows of "padding" at the bottom of
the 4 columns in Sheet1? They contain formulas that evaluate to zero from
each of the linked files in case I add people to those lists.

--
David