Cross-reference 3 lists to return all available employees

Hello, I am a super noob to vba but I have learned quite a lot on this board.
I have three lists, one with a list of every state and all employees that are available to work in each state (ranges from 3 to 12 employees in each state), then another list with different limits (dollar amount) of authority that each employee has, the third list is a schedule of who is working on each day of the month. What I'm looking to do is write vba that would, based on the state that is input into a cell and todays date, look at the first list to see which employees are available in that particular state, then look the the second list to see which employee has the particular authority to do the work (dollar amount), then look at the schedule to see who is available that meets the first two criteria. Right now we are just using IF statements that refer to 5 different tables to determine who can work in each state, the rest of the information we are just looking up manually. Thanks in advance.

Thanks FDibbins,
Here's a quick example of what I would like. It's not the workbook I am currently using, that would take some time to clean up. Basically, we would be pasting information on the "Input" sheet in columns A and B. I would like the code to look at the "Table" sheet to see based on the amount, today's date, and the state who would be available to work and list them in column Don the first sheet. I could combine some of the information (authority and schedule) if needed.

I know. That's where it gets complicated. Some people can do work in many states.

I think I may need to re-arrange my starting information. Maybe put the states first, then the employees for each state, then the authority amount then the schedule so it weeds them out as it goes down the line. What I would ultimately like is to just paste in a list of amounts and states (about 30 or so a day) on the "Input" tab and run a macro or have formulas nested that would return a list of available employees in column D on that same tab. So it would just look through all of the info on the "Table" sheet and return the answers on "Input".

Yes, I saw it. I'm still trying to wrap my head around it. I see how you put everything together on the table, I don't understand the amount columns (L-P). Do they just return the available employees at the bottom of the columns then you have to paste them onto the Input tab? I really appreciate the help. Like I said, I'm still learning so I have to go real slow through all of the formulas and figure out what they are pointing to. I'll try to apply this to the full workbook and see how it goes. Thank you.