Trying to pull data in a specified range, offset from a found cell, into another worksheet

[DtDrThunder]

Ok, I used to do this regularly but the last time I used VBA was 8 years ago. I will hopefully explain myself well...

I have a column of data (it is all text but includes letters and numbers). I want to search that column of data for a partial match to the cell value (X) on a different worksheet. Once that cell is found in the column (X) I then want to search the 18 cells above that cell (in the same column) for text containing a different partial match (A) and then copy/pasting those matches (there will be more than one) into the correct column that corresponds with the original cell (X) on the other worksheet. The multiple matches can spill down the column.

I can't upload pics of the data column as it is private data. If necessary I can make a fake data column.

Thanks for any and all help!