Hello, and welcome to the forum.
It sounds like your control sheet (sheet1?) has form or button controls that have VBA code linked to them selecting the correct data sheet. If so, then the control sheet options can be amended, but how would depend on what changes you need to make. I think that we will need more information, and to see your spreadsheet in order to help you.
I don't think you need many posts to become a regular user (5 or 6) I think.
HTH
Hercules
Bookmarks