I'm sure it happens all the time from a logical perspective without the user even knowing what a shard is. Example: Too many rows? Okay let's just break it up

I'm sure it happens all the time from a logical perspective without the user even knowing what a shard is. Example: Too many rows? Okay let's just break it up into monthly sheets and then change this formula to look up the value based on the month. Maybe just use a drop-down for the sheet selection. I think most people could arrive at this answer intuitively who have enough excel experience.