Excel Links & Dynamic Named References

[RG19]

Hi guys, I hope you are all well. I have taken over a report which is done across 3 workbooks with the aim of automating it as much as possible. In Workbook A I have created a lot of dynamic named ranges and reference them in Workbook B. Originally, I used the offset method of dynamic ranges, but figured out that they didn't work and now I know they don't work on closed workbooks. Therefore I have changed to index match based but i still can't get them to work either??? Any help would be greatly appreciated. Thanks RG 19 Apologies if this has been posted before I searched all over and this is a last resort

 

[Derek Brown]

Harlan Grove's PULL function may be what you need but I have never used it.
Do a Google search for "Harlan Grove PULL" and see what people say about it - the following gives a link to the download page:
http://www.contextures.com/xlFunctions05.html