Sure, I have 3 work books. 1 is a list of customers with accompaning data, 1 is an invoice template, and 1 is a timesheet template. The timesheet and invoice both need to contain data from the customer data workbook, and there will be more workbooks developed that will rely on the same Customer data. However, there is some information in the customer workbook that we do not want employees to have access to, so the option of linking directly to is is ruled out. The customer's data book is constantly changing as customers are being added, removed and changed in general. The customer data book also have referenced names that are used to populate fields in the invoice and timesheet. So what I would like to do is create an "update macro". I would like to copy the sheet from the Customer's Data Workbook into the Timesheet or invoice template so that the formulas can be referenced independently within its book. However, the problem i'm running into is whenever it copies it over, it renames the sheet ('Sheet1 (1)') rather than overwriting the existing sheet in the timesheet/invoice. So in essense, I have Sheet1, Sheet1 (1), Sheet1 (2), etc. When my vlookup formula goes to look for it, it is looking at the old unrenamed sheet, and populating old information.