Data Validation (Dynamic) Drop Down WITH COMBO BOX on DOUBLE CLICK, INDIRECT not working

Hi, I have made some drop down menus using the data validation technique. This is a three tier system and it works perfectly fine. However I have decided to add a combo box overlay that appears on double click using the code below. This works for the first set of drop downs, but not the second and third tier (I'd imagine because they use INDIRECT, within the sourcing). I have attached the file that I am working with, any help is appreciated.

Please Login or Register  to view this content.

I have tried using the following, to convert the "indirects" to proper cell references but have had no luck.

Please Login or Register  to view this content.