Sorry for the late reply, wedzmer.
I suddenly ran out of my internet airtime since we were last connected, and I first had to replinish same.
There is nothing wrong with the formula you are using, except that it uses the Row on which it is, to return any data from the sheet it refers to, on the same Row, i.e. Row 13.
The solution could be to change the layout of your (1) July-Master List, as shown in the attached sample Workbook, where I have used the (1) June-Master List, for demonstration purposes.
If that works for you, and if it does not affect any other sheets using the same type of formula, all you have to do, is to change the layout of the (1) July-Master List to be the same as the sample Workbook for (1) June-Master List.
One VERY IMPORTANT thing to remember is to protect the Master Lists, so that nobody can insert or delete any Rows. That should solve your issue.
Hope that helps.
Regards.
Bookmarks