would you consider only having one summary sheet and
use auto filter to show any of the 25 sub sheets?

"av8tor9804" wrote:

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.