Userform to enter data in multiple worksheets

[zookeeper94]

Hi,

I am a beginner to excel and am in dire need of help.

Basically, i have created an excel file to record various daily aspects of animals at a zoo e.g. food, enrichment, behavior, medical data etc. with each individual worksheet being for an individual animal/group of animals all formatted in the exact same way.

My hope is to create a userform which will contain a drop down menu to select which sheet the data is to be entered in (e.g. which animal the data is being recorded for) and then various text boxes for all the variables (and sub variables in some instances).

However as I mentioned, I am a complete beginner regarding this so I have no idea how to even begin the coding for this process or of this is even possible.

I have attached the template file that I am working with. I am definitely reaching far beyond my abilities with this one so any and all help would be much appreciated. Thanks