Nested IF Index Match formula reached limit. Suggestions?

Hello, I am trying to accomplish a nested IF Index Match, and I hit the wall for number of nested allowed. I know somebody out there has to have a better way of doing this. If possible, I want to use a formula that does not need a reference table or use VBA code. What I'm looking to do here is on a quote form, reference an external price sheet document with multiple sheets for different categories of product. Each of these sheets has consecutive columns with different price levels. I'm sure if you look at the below formula, you'll see the pattern:

=IF($H$35=1,...!D$1:D$65536,
=IF($H$35=4,...!F$1:F$65536,
=IF($H$35=7,...!H$1:H$65536,

Below is the actual formula that works, but again I've nested too much and Excel won't allow this to continue (and probably for good reason). I need to continue the above pattern to include $H$35 cell reference to: 8 and !J$1:J$65536 then in addition 9 and !L$1:L$65536

=IF($H$35=1,IFERROR(INDEX('F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]DVR SYSTEMS & COMPONENTS'!D$1:D$65536,MATCH(B14,'F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]DVR SYSTEMS & COMPONENTS'!A$1:A$65536,0)),IFERROR(INDEX('F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]WI-FI DVR SYSTEMS'!D$1:D$65536,MATCH(B14,'F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]WI-FI DVR SYSTEMS'!A$1:A$65536,0)),"")),
IF($H$35=4,IFERROR(INDEX('F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]DVR SYSTEMS & COMPONENTS'!F$1:F$65536,MATCH(B14,'F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]DVR SYSTEMS & COMPONENTS'!A$1:A$65536,0)),IFERROR(INDEX('F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]WI-FI DVR SYSTEMS'!F$1:F$65536,MATCH(B14,'F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]WI-FI DVR SYSTEMS'!A$1:A$65536,0)),"")),
IF($H$35=7,IFERROR(INDEX('F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]DVR SYSTEMS & COMPONENTS'!H$1:H$65536,MATCH(B14,'F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]DVR SYSTEMS & COMPONENTS'!A$1:A$65536,0)),IFERROR(INDEX('F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]WI-FI DVR SYSTEMS'!H$1:H$65536,MATCH(B14,'F:\CUSTOMER PRICE SHEETS\PRICE LISTS\[PRICE LIST.xls]WI-FI DVR SYSTEMS'!A$1:A$65536,0)),"")))))

I tried to figure out a dynamic shorter formula to reference a cell on the main quote form to change the letter in this part of the formula: !D$1:D$65536
However I could not make it happen.

I would be grateful for expert assistance, because through all of my web searching and experimenting, I cannot figure this out. Thanks in advance!