Create a toggle to either create a new sheet or view if sheet already exists

[rp0167]

Looking for suggestions/example of the best method for creating or viewing a sheet. Have a bid/budget template with about 100 line items. For each line item there is a bid tab where we enter bidders pricing. On the main budget page I'm looking to have a button for example that says CREATE or VIEW depending on if the sheet has already been created. So first time this budget will all say CREATE and I will click which will then copy a template sheet and name it the budget line item name. Example is I have a line item named Fence. Then click the button to CREATE the bid sheet where I will enter bids. Once the sheet has been created the button name will now switch to say VIEW. So then I can go back and view this sheet name. Because I will have so many sheets I planned to hide all sheets unless I clicked on view. Again looking for best method suggestions or examples.

[Mumps1]

If the button name changes to VIEW, what happens if you want to create a new sheet? I would suggest to use two buttons instead of one, a VIEW button and a CREATE button. This way you could perform either action at any time. Also, it would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.