Create sheets from templates selected according to cell data

Hello,

Can anyone help in cranking out the VBA.

I have a "Master" sheet with 2 columns : "TYPE" and "NAME" and I have a command button (ActiveX Controls) created and named it "CREATE SHEET"
And, I have 2 other sheets namely "TEMPLATE A" & "TEMPLATE B".



What I would like to do is:
EXAMPLE:

TYPE NAME
A LP1
B DP1

So when I click, "CREATE SHEETS" button, I want Sheet LP1 to be created as per TEMPLATE A and Sheet DP1 created as per TEMPLATE B.

If I enter a new TYPE and NAME in after creating sheets, it should only create the NEW data it detects and create only that sheet.

Seems a lil complex. But i appreciate any help please.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Excel VBA" is not a good title. I have updated it for you this time because you are a new member. --6StringJazzer

Try to attach a sample workbook.