You really need to restructure the table as I described before, into a
continuous (no line breaks, no merged cells) table. Your options go
up 300% if you do this.

You can create a macro or a little VBA code to copy the cell entries,
but assuming your current data is not too large, just copy what you
need and recommend your users adopt the new table style. As you can
see, they will only see their info (with just a few mouse clicks to
filter), and you will have many more reporting options.