I am very new to VBA and after hours of searching I have found a code to copy all rows of data from multiple workbooks into a master workbook. The data in the user workbooks is updated daily. However, I do not wish to delete the data from the user workbooks so when I run the macro for a second time to capture the new data, it copies all the rows again and therefore duplicates the data in the master workbook. Column T of the workbooks contains the week number of the entry of the row of data. I would like to use an input box to specify the week number to search for, then copy the entire row. This way I can run the macro once a week but only update the master with the previous weeks data instead of the entire worksheet. Here is the macro I currently have. Please can anyone help to modify it?I am very new to VBA and after hours of searchi