Hello. First of all, I'm completely new to Macros, so I've got no experience. What I need to do is combine data, into a single table in a single worksheet, from around 200 different workbooks. Each workbook has multiple worksheets, but I only need one particular worksheet from each workbook. The worksheet's name is the same in every workbook and so is the format. I need the data located in each of these worksheets to combine in one single sheet in a separate workbook. Any ideas? Thanks!