Adding new worksheets to an array

[itsunclebill]

I'm in the middle of a project to compare like items from differen
vendors. I have set this up so that each vendor gets a separat
worksheet for entering prices (that need to be updated regularly)tha
is named for the vendor when the name is typed in at the top of th
sheet. I have another page where all the pricing on like items fro
different vendors is compared and the lowest price on an item i
displayed and which vendor has the lowest price

My issue is that when I add a vendor I have to go in and manually buil
all the links to the new sheet. Is there a way I can have a newl
named sheet add itself to my list of sheets to be compared? Or, a
least a reasonably easy way to do this manually?

Essentially, my process now is to have a vendor template sheet tha
gets copied, then renamed. Then I have to click several hunder
items in the new sheet to make the new links to compare the items adde
to the list of names and items on the page where the comparisons ar
done. Or, is there a better way to do this?

Thank

 

[Earl Kiosterud]

Uncle Bill,

Put them all in one sheet with a column for vendor.