Hello MJAHNKE and Welcome to Excel Forum.
From the description you want dependent drop downs that reference tables which is a topic covered beginning at 13:21 of the video linked below. That each table is on a separate sheet may complicate the matter, hence the following suggestion.
Please upload a small desensitized sample of the workbook so that we can test formulas/code using your setup. To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
https://www.youtube.com/watch?v=ws63XhhQi1o
Let us know if you have any questions.