You can create a user form for every sheet, form that apears to user when selecting the sheet, like in picture attached.. But the best approach depends on the ammount of information that the user must enter. If there are just a few entries, it's easier to use application.inputbox.
You better upload a sample workbook, indicating what fields you need in every sheet, you will get faster answers...
|