I have a Workbook that I am working on that has multiple worksheets in them

What I have done is created a setup tab

On the setup tab I have In Column A I have Various values entered in usually
in sequential order

In Column B is the Maximum Value that can be entered in if someone chooses
something from Column A

In worksheet 2 I have created a List that contains the values from
Setup!A2:A40
I want to have Data validation work so that no one can enter a value above
the number entered for the Value in Column B of Setup!B(Whatever)

Any help on this would be appreciated cause I can not seem to get it to work
the way I want it.