I think that userform is going to be my best option but I have not had much experience with userform. What I am wanting to do is have a primary userform that will be On Open. It will have the date and then the sheet name, preferably from a dropdown list. I would also like it to populate if a new sheet is created. Once it is run it will open a userform based on the sheet listed. I also want it to send the date from the primary form as well as the information from the secondary form entered on the sheet. I am not sure where to start in creating this. Any help would be greatly appreciated. Thank you in advance.