VBA

I have created a new work book that contains three tabs. The first two tabs are effectively summary tabs that feed off from the third tab which is the source tab.

Within the summary tabs I have created summary tables that automatically pick up the required information from the source tab.

Now the challenge that I'm facing is the number of source tabs used may vary according to what work is being carried out. This means that whenever a new source tab is inserted I have to manually update the summary tables by including a new row and copying the formulas from the above row and then changing the source name in the formula to reflect the new tab.

What I would like to achieve is the following.

1) to create a macro that when run will automatically create a copy of the source tab and move to the end.

2) The summary tables will automatically insert new rows at the bottom of the table which has the same format and the formulas to pick up the new name of the source tab

3) Finally to include a time stamp that shows the date and time the form was signed off. Ideally I would like to protect this time stamp cell with a password so that no one can change it.

I hope this makes sense.

Please let me know if you would like me to share my workbook.

Best Regards.
Yusuf