appending worksheet records

I've numerous spreadsheets (~680) with multiple worksheets, (worksheets
identically formatted and named)

I wish to merge/append the row records' values of coinciding worksheets into
a master prior to export to Access. What is best way to automate a such a
process?
no records will be combined just appended under one another.

merge or consolidate are inadequate from what I can see as they seem to
require uniquely named worksheets (even thought the combination of Workbook
and Worksheet would uniquely identify them) they also seem to have a lot of
overhead in setup - paint, copy and paste would seem faster

--
Jim