Hello- I have been searching for code that will help me copy a specific range of data from many worksheets within a workbook and paste it into a new workbook. I have worksheets names Day1-Day31 and I need to copy cells with data in the range from cells A69:C75 into the first blank row in a Master workbook. I know I can go back and forth activating the different workbooks and selecting each worksheet to accomplish this, but that would make for a very long code. Any advice would be appreciated. Thank you for you help in advance.