I'm trying to use Data Validation "List" for the following:

In cell (A1) is List 1, in cell (B1) is List 2.

Function:
Make a selection from List 1, then a required selection from List 2. The
results of combined List 1 & 2 point to a separate worksheet (either in same
workbook or separate workbook), specifically defined by the results from List
1 & 2.

Is this possible, or what are the alternatives?