Move EntireRow below Table1 if range in table contains specific word

Hi all :-)

I am completely clueless on how to do this one (my VBA skills are very limited)… For the attached sheet, I need a vba script that checks Range("B") inside "Table1" for any cells with the word "TEST", and IF (the word isn't always there) that specific word is there, then move the entire row of that cell below the table and create and add to a "Table2", and hereby exclude the "test"-row from Table1.

If any help, the layout of Table1 is "fixed", and will always start with headers in A7:I7, but the length of the data is variable. Also, there will always be a number in A to the data.

On the first row below Table1 - and also the first row below the newly created Table2 (if it is created), there must be a SUM([Field 1]), SUM([Field 2]) and SUM([FIELD 3])

I attached two sheets, one with the basic data and one that looks like it is supposed to, after the VBA :-)

I know it might sound confusing, so please just ask if anything :-)