Creating a new customised Excel workbook from a main workbook

Registration date
Thursday October 31, 2013
Last seen
October 31, 2013

First it is nice to join you in this forum, hoping I can add value in the future to whatever endeavors you have been delivering till date.

I would like to ask your most appreciated assistance in the following :
a- Having a main program workbook, including list of column H,
b- to create a new workbook (from another predefined workbook) with the name of the only newly added project and add its hyperlink, in the same row, column I.

Hoping this is not much,
your Assistance will be highly appreciated.

Take care and hear from you soon