That's great, it works perfectly.

Have one last issue though. When I delete the data from the original workbook the info is also deleted from the newly saved sheet 3. How can I save the sheet with values only, not the formula that are linking back to the original wb?