I did a Google seach and came up empty so here is a question:

In Row 1, on the Vendor worksheet, I enter new vendor business names and
input some general info in their column. I then create a separte worksheet
for that vendor,the sheet is named for the vendor, and I put in the Text
lables and formulas to mimick the worksheets fror all the other vendors.
Is there a way to have this done automatically when ever a new vendor is
entered into the Vendor worksheet.

Please help.
Thank you
Kevin