Data not ported to another sheet where previously it worked as intended

[Kevan11]

Hello, this is my first time here so I hope I describe my issue properly.

I have a google sheet that is currently used to track the leaves that are coming in and being approved. The workflow works like this.
1. Applied leaves online goes into a sheet named 'leave request'.
2. I approve it with an X, on the sheet itself and it automatically transfers the data to 'Master Data'
3. From 'Master Data', the data will get pulled to 'view breakdown' sheet.
4. There is a breakdown of the data per individual which is viewable at 'view breakdown' sheet.

The issue:
1. For some unknown reason, the individual data does not show the complete data, and this is happening for random individuals (doesn't look like it's date/month related)
2. As an example, I put the individual S, which we can view the full complete data up to December 2021. However, for individual K, the leave in December does not show up.

I was scratching my head for a few days, trying to see where it went wrong but just couldn't figure it out. So I hope someone can help me see where did the problem arise.

This is the google sheet below. Thank you.
docs.google.com/spreadsheets/d/1knQbcQnroLZ6dIcPTNerwwW3EzsloWDoeIMD0yB4ARg/edit#gid=0

[janmorris]

the problem is the Named Range "data"

it is missing the last row.

so when it is changed to 'Master Data'!A2:AB112 then everything shows properly.

i have already made the adjustment for you.

if you get continued problems then you may want to look into the method to create Dynamic Named Ranges for G-Sheets.

here is a tutorial: https://www.benlcollins.com/formula-...-named-ranges/

screenshot from the tutorial:

[Kevan11]

Thank you very much!!