I need to create a master “database” in an Excel Workbook by copying data (using “paste special value”) from data contained in about 230 separate Excel Workbooks.

The 230 separate Workbooks are contained in a unique folder and all have four digit numeric names. These Workbooks contain a common Sheet named “Upload” that contains the data to be accumulated into the master. The “Upload” Sheet contains a fixed range (not named, A3:AH253) containing the data to be accumulated. The data “fields” within the named range are identical throughout. The data does not need to be consolidated. The 230 separate ranges need to be appended to each other to create what I am calling the master “database”.

Once the master “database” is created, the data will be converted to a CVS file and uploaded into an accounting system.

Can someone take a shot at helping create the master “database” or direct me to thead(s) that show how this might be done? I am a bit green in this area. Your assistance would be greatly appreciated by someone who does not like manual processing. Thanks.