I have several named ranges, all the same shape and size.

In another workbook I want to pull through the data from the cell on the 3rd
row, 4th column of each named range.

I don't want to refer to the absolute cell reference as they might get moved
about.

Is this something that can be done easily?

Thank you