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.