Search for a specific cell value and relocate the two cell to the right it !

Hi i have a couple of textfiles that i import to excel whit spacedelimiter.

The text file can look verry difrent from time to time but one thing is always constant: Place, Name and Amount (se below)
Sales1 (Place) Petter (Name) 552 (amount)

And i want to take out specific values from the imported txt.

Textfile can look something like this:

021124 Kiruna Steinholz Sales1 Petter 552 Out
021125 Sales2 Mats 456 Gross Out Ok

Texfile in excel:
Is there any formula or vba macro where i can search for "Sale" in range (A1:Z1000) and relocate all the cells with sale in it and two cells to the right to a new location lets say Col AA Col AB Col AC ?

Ex from the textfile above:

Sales1 Petter 552 moves to Row1 Col AA, Col AB, Col AC
Sales2 Mats 456 moves to Row2 Col AB, Col AC

Best regards

Petter