Is there a better/more efficient way to use Indirect, sumproduct and Define Name

Hi
I have 2 workbooks and workbook 1 reference to workbook 2.

Workbook 1 will be using "flexible" indirect to reference to workbook 2.
It will have a separate cell for:
- the name of workbook2
- the worksheet name in workbook2
- list of certain account
- a complete list of account
- the month amount required


Workbook 2
It will have a:
- A table with all the complete list of accounts, amounts and months
- Defined Names for all the account, the months, and a set of account I want a total for


Is there a better way to use indirect with some flexibility as shown in Workbook1 by referencing or just one place to input the name of the workbook, worksheet, list of account codes (defined name), selection of account codes (defined name) and Month's total.

I don't think the Month Amount or MayAmt is use effectively. I guess I should use Index and Match for it but not sure how to use it together with sumproduct. I have posted a separate thread for it. But if you can assist both questions in this thread that will be great as well.

Thanks.

Hi ALiGW
The other thread resolve one part of the query, the other part of the query is to find out how others use indirect with some flexibility.

I am currently using "input" cells to define the workbook name, worksheet, etc. Is there another better way to do that?

Thanks.