Copy 2 Worksheets to named Workbook VBA

[AndyJC]

Hi, I want to be able to copy two worksheets "Buy" & "Sell" from Workbook 1 to a named Workbook in a specific location however, the workbook name will change on a daily basis.

- Copy "Buy" &"Sell" worksheets from Workbook 1
- Open "C:\Documents\Test1" workbook. This file name is found in Cell A1 in the "Buy" worksheet.
- Paste "Buy" & "Sell" as the first two tabs in "Test1" Workbook.

Any help on the code will be of great assistance.

Many thanks
Andy