Using Indirect function to reference another Workbook using Named Ranges.

[julhs]

I apologise in advance if there is overkill in info, but in the past I’ve fallen foul of NOT providing enough!!
I have 2 Workbooks, Book1 is the active book and Book2 is the source.
I have the same “Existing” named anges (used for other purposes) in BOTH Books that I want to utilise.

In Book1 I have 2 Data Validation lists, the 1st one (in D32) is the primary and the 2nd (in D33) is a dependent dynamic list based on selection made in the 1st one
I have the 1st VD list working; directly referencing a "Named Range" in Book2
BUT I can’t compile the “Indirect” formula for the dependent 2nd list to reference the appropriate Named Range in Book2
At the moment I have a work around solution for the dependent 2nd list but it’s NOT utilising the existing “Named ranges”, so I had to create new ones in Book1 that use “Book2>Sheet Name>Range”.
So what I have so far is:
This is working using named range
In Book1, 1st VD list

Source: = ChemicalSuppliersList_Condensed (is a defined named in Book1 referencing a defined named range in Book2)

The source named range above,

Refers to: ='Book2.xlsm'!ChemicalSuppliersList_Condensed

BUT currently the dependent 2nd VB list in Book1 is ONLY working if I have a defind name in this format

Source = [Book2.xlsm]Sheet??’!$C$6:$C$29

So after all the background stuff, the essential question is; how do I compile an Indirect formula in Book1 to reference the “Named Ranges” in Book2
Something like:

Source = Indirect(D33) = ‘Book2.xlsm’!Named Range in Book2