Lookup An Entire Array?

Hello All!

I have a small workbook with 2 sheets that help me with payroll projections for my sales reps.

The first sheet is a summary sheet that auto calculates based on quite a few formulas. In the top left corner of this sheet (A1) I have the first name of the sales rep (with the first letter capitalized).

The second sheet is filled with 21 seperate small arrays. Each array is a specific payscale for each rep. I've selected each array and TITLED the array by the reps' first name.

My goal is to write a formula that allows me to reference the reps' name on sheet 1, and lookup the appropriate array. As I change the first name in the top left hand corner of sheet one (A1), I want the formula I write to reference the corresponding array on sheet 2.

Summary: (First name changes (cell A1 on sheet 1) and the array which the formula references changes since the title of each array is each reps' first name).

Please let me know if you have any thoughts!!!