Automatically create a column in one table from the totals column in another table

I am writing a VBA script to automatically create a new table on a new worksheet from a template sheet in my workbook. The table in the template is for the number of hours worked on a set of projects (the rows) and has columns for each month in two calendar years and a "YTD" total column on the far right which sums up the data in each row of the table.

Some additional functionality I've added to the script is to rename the new sheets and tables so they can be found easily with reference to a roster table.

The final piece of functionality I want to add is to automatically create a new column in an existing summary table which refers to the YTD column of each sheet in the workbook.

Here's my code so far:

Formula:

Please Login or Register  to view this content.

Oh, and thank you in advance for any help you folks can provide!!

Bump. Any gurus out there with advice?

Since I have had no takers, and I don't want to waste any more time working at this particular problem, I have re-thought my approach. Instead of adding a column to a static sheet every time I add a new member, I am going to procedurally create a summary table on demand.