In Sheet1 of my Excel spreadsheet, Microsoft Forms is appending new rows as responses come in. These contain various columns of data.

I'd like to create another Sheet2 which provides as summary view of that data sorted in a particular way. (My understanding was this was the right thing to do rather than sorting Sheet1 directly, to avoid syncing issues.)

This formula works well for what I want to do:

= VSTACK(
    Sheet1!A1:Z1, 
    SORTBY(
        Sheet1!A2:Z1000,
        XMATCH(
            Sheet1!G2:G1000, 
            {"Strongly Agree","Agree","Neutral","Disagree","Strongly Disagree"}),
        1,Sheet1!F2:F1000, 1,   Sheet1!E2:E1000, 1))

However, when a new response comes in from Forms. The entire Sheet2 entries disappear and there's a #VALUE1 in A1. If I paste in this same formula, then it works again. Is there any way to keep this up to date? Is it hitting a race condition or something? How to avoid it? Or simply a better way to make a sorted view (which will be presentable to anyone Shared to that view)?