Thank you so much.

I apologoze about the delay in re-checking the responses here. It's been a
busy couple of days. I have downloaded the file and will check it out
shortly.

Thanks again.
BL


"Ardus Petus" wrote:

Here is your "Combined" Workbook with a macro named fillRows:
http://cjoint.com/?dhnhlyBWGv

HTH
--
AP

"av8tor9804" a écrit dans le message
de ...
I have included a couple of the 25 workbooks, as well as the Combined
workbook, for you to download and play with to see what I'm describing.
You
can download the ZIP file from www.runsheets.com

I need the latest row(currently Row 21 for N567, and Row 33 for N123) to
automatically paste/hyperlink/update to the Combined workbook.

Thanks for any assistance you may provide.

BL





"Ardus Petus" wrote:

So you'll need some macro code (VBA).

Should the source data lines (ie A:Z) be copied into the same columns
into
dest (master) worksheet?

Cheers,
--
AP

"av8tor9804" a écrit dans le
message
de ...
No. Each spreadsheet may/will vary, as far as row numbers.

"Ardus Petus" wrote:

Has the "latest" row in each worksheet the same row number?

--
AP

"av8tor9804" a écrit dans le
message
de ...
I am trying to update 25 different spreadsheets, and have the
latest
row
of
data from each of the 25 automatically go to a 26th spreadsheet
that
is my
summary.

My goal is anytime I add a new row of data in any of the 25, that
the
summary sheet gets updated automatically.