AB33 there will be an exact match.. Some of these components are marked XX for reference but not all sheets have this.

So if i just put the code sFind = "XX" under the code sFind = X thats all I need to change?

And for the columns, unfortunately we use a program that spits these BOMs out into this certain format so there is information spread across a couple columns (as you can see).

I would need:
Columns D-E (supplier detail no)
Columns J-L (name)
Column M (material)
Columns N-P (specs)
Columns Q - T are fine the way they are
and if possible it would be good to show column X.