I have 74 Excel workbooks all with a common worksheet named Data. How can I merge all 74 Data worksheets into 1 master workbook and worksheet? The headers (Column A-AZ Row 1) are the same. There are other worksheets in all the files, but I am only interested in merging the Data worksheet. All 74 workbooks are in a folder on my desktop. Any help is appreciated. Thank you.