INDEX & MATCH Formula

Hang on... you're overcomplicating htis (and so am I). Why can't you delete everthing in BVA each update and just paste the new stuff in. Providing the headings don't change, your Table will update. In reality, you don't need iNDEX-MATCH, as you're just using it to rearrange data. See a simpler alternative in Sheet1 - that you can pretty up. Alternatively, use your existing format in your own report format. It's not doing any harm!!