Sounds like you're using the wrong macro from my site. You should be using PART 4 to bring in data from multiple worksheets into a master workbook where the sheet names match. Use the link in post #2, use the correct macro.