Hi Guys!

I'm trying to work out a macro that will use certain worksheets from a workbook, to produce another workbook.

Basically Workbook 1 (main) contains 8 worksheets.

I want a button that will:
  • Create A New Workbook (Workbook 2)
  • Insert Worksheets A, B & D from Workbook 1

I want another button that will:
  • Create A New Workbook (Workbook 3)
  • Insert Worksheets A, C & E from Workbook 1

Any help would me much appreciated!!

Thanks
Dave