how to change this macro so it makes sheets in a new book not in the current book

This Macro is working but i want the new sheets to made in a new workbook
2 things i'd like to change in this macro.

1) Can it create these new worksheets in a new workbook.
2) Either can the new sheets have an ascending number in A1 or can the sheets name be copied into H1. Both options have the same result H1 is a lookup based on A1 value.

Please Login or Register  to view this content.

I found this function for adding a worksheet name to a cell, thank you Kevin B

HTML Code: 

Please Login or Register  to view this content.

But i've not tried using a function and a sub in 1 code before?

The reason for this is there is a drop down box on the original sheet so you can choose a walk name it then does lots of lookups and shows you all the details for that walk. But to print you have to select each walk separately. With this macro you can select print entire workbook and it should save a lot of time.

Thanks in advance

Maybe this:

Please Login or Register  to view this content.