Formula Needed for an Advanced Spreadsheet to Determine Inventory Count

I apologize for probably not giving the best title, however, I am desperately trying to write a formula.
We have a spreadsheet that pulls data from various other spreadsheets that contain information on current year data, budget year data, and last year data. We need to pull from the current year spreadsheet information each month on the inventory count on hand.
We need one formula in one cell of the main spreadsheet that will know to pull from the appropriate month column of the current year spreadsheet based on the particular month we are running the report for. Hopefully, this is not totally confusing as written.
In other words, we are not wanting to need to change the formula each month, but to write it such that it will know by our indicating in the main spreadsheet which month it is (which is always indicated in Cell B14).
In the main spreadsheet, the cell containing spreadsheet information on where to find the current year data is $D$2.

Please help if you can.

I can't post the spreadsheet due to confidentiality. However, I can try to give you all the necessary names, etc. that you need. Sorry for the omission.

Each worksheet is separate and there is only 1 worksheet in each workbook.

Cell D2 of the Main Workbook contains the location of the workbook containing the Current Year data. ''[Name-export-2014-01.xls]

Cell B14 of the Main Workbook contains the month information. "1" (for January)

The main workbook is "[Report 2014-wBudget.xls]

The same cell does NOT contain the inventory count each month. The workbook ultimately contains an entire year's data by year end. The data for January is in cell H364. So I364 would contain the Feb count.

Currently my formula reads: =LOOKUP(INDIRECT($D$2&"Dealer1'!$H364"),0)
But this is obviously not correct.

Also note that in the Current Year workbook, there are worksheets for Dealers 1 - 20. Thereby, you see Dealer1 in this formula.

In the main workbook, there are columns for each Dealer 1 - 20. So once the formula is correct, it will be different in each column to reflect the different Dealer #s.

My formula now reads:

=VLOOKUP(INDIRECT($D$2,'Month=Col''s'!$H$8:$S$19),$H$2,0)

It still does not work. I get #VALUE!

I wish I understood more about these formulas.

The main workbook is too large to upload.

The size is 4 MB. I'll look to see if that is possible.