I have searched for an answer but am unable to make anything work. I have 13 worksheets in one workbook. The first worksheet is the summary sheet and the subsequent sheets are the months of the year. At the end of each month, I copy and paste the previous months' worksheet into the current months' worksheet. At the beginning of each month, I need to pull two columns of data into the summary sheet. In cell Y4 of the Summary sheet, I have the month coded as =TEXT(TODAY(),'MMMM"). I want to update column B and G from the data in the corresponding month worksheet (if it is currently August, data should be pulled from worksheet "Aug"). The data to be copied is always located in columns C and Y. I only want to update the data once a month using a button, I do not want the data to update automatically. Any assistance would be greatly appreciated.