Macro needed to create new worksheets and feed through specific data

Hi,

I have attached 2 spreadsheets - Test1 & Test2 to assist with my problem.

Test1 is where I currently hold information about accounts. However, I have come across the problem if new accounts are created.

Is there a macro I can use that will extract the data from Test2 and create a new worksheet in Test1 containg all the inforamtion I need? I will then also need the new worksheet to be renamed after 'Code_2'.

In the future there is potential for several dozen new accounts that will needed to be added to Test1 so this macro can't be specific for just the example I have illustrated in Test2.

Any help would be much appreciated.

Thanks