Hello all I have a general question which is
Can you design a data entry form that places the data into a specific labeled worksheet (tab) in a shared work book .
Currently I get paper request which has general info such as date , time , book however the discipline is specific. I have one work book with different tabs for the disciplines
disciplins tabs .jpg

Is there any way that a form may be created and based on the discipline selected , the info is saved into that specific tab.

Just trying to minimize time and paper
many thanks