Copying a range based on the value of a call

Hi,

Major VBA noob here...

I have a cell in "extractdata" tab, at B2 which finds a word in a data dump. THis returns the row that the word appears. I want to copy a range, stopping at the row where the word appears.

I.e. In B2 the value is 1900 for example,

I want to copy the data from B3:G(value in B2)

How can i do this in VBA? Sorry i am very very new at it, so please keep it as simple as you can!

Thanks for any help