appending worksheet records into 1 worksheet
 

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

I wish to merge/append the records 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 to one another.
--
Jim