I'm not sure if I'm taking the most difficult road to complete this task, and if there is a easier way to accomplish this please let me know!
I have a workbook with the first sheet titled "Master". One this page there is a button linked with a form. This form has a drop down list of different workbook pages. I want to input data into the form, and then have it go to the table I have made on the "Master" sheet AND on the workbook that was selected. The form currently does submit the information to the Master Sheet. I'm thinking of either putting a formula into the form or onto the data table to send the information from there.
I have been trying to accomplish this for week! Please help!