VBA: I need to store data instead of only keeping 1 number at a time

Good Day All,

In my pictures you can see two of my sheets, the first displays a portion of the GUI the user will input information into and the second is one of my data sheets which stores numbers depending on who is selected in my drop down menu. My problem is right now when I switch users in the dropdown menu in cell P5 and enter new information in C9 all the information I had for any previous users data will be erased and put as "FALSE". Is there a way I can store the information in cells G3:G11 of my data sheet so that when I switch users and their data sheet is updates all my other sheets don't return to "FALSE"?
A little more explanation for this if you need it is that there are 14 users in the drop down menu and each of them has their own data sheet. In the end I am looking for multiple people to be able to use this excel document as a shared document rather than everyone having their own copy of it.
Any help would be greatly appreciated.

J

You would need VBA for this. Shall I move the thread to the correct section of the forum for you?

There are instructions at the top of the page explaining how to attach your sample workbook.

I have moved the thread.

A workbook is worth a thousand pictures and will get a solution far quicker

Sorry, been busy, so a couple of days have passed quickly.
As I see your app - 1) how to enter and store the record data efficiently - this needs to be tabulated for easy retreval - this would be a nightmare if you have a repetion of your WEEK1 sheet - (how many weeks x how many members ??? 20 members x 50 weeks are 1,000 sheets manageable).
I would suggest your data is stored in a table (similar) to my attached file and you have ONE template that the data is loaded to for viewing.
The attached file is just to illustrate the method of data entry & storage - the template would be based on how you envisage wanting to view the data.
I have attached also a calendar/appointments book illustrating how you only need templates rather than individual sheets with data stored in hundreds of locations.
The calendar is just one sheet however it has the capacity to store and display 20 years worth of data/appointments.
Do not enter data in the white space - just double click and a data entry box appears - if data present double click to edit.
Give the process some thought and post back on this site if you want to progress this.