Macro to search copy and paste

[sdoppke]

Morning everyone, I have searched and found several threads that address this, none hta actually work for me.

I am looking for a macro that will search all worksheets in all open workbooks (except the master one that contains the macro) for just one value in a sentence (a store number "123"). i.e. the cell will say "store 123 at 49th Ave NE New York, New York"

Then it needs to do what control shift down does (copies everything down) and then control shift right(copy everything right) All from the point of the cell it found that had the specific store number.

Then paste it starting from cell A3 on master excel sheet.

Thanks in advance for any help. I hope my description wasnt to vague.

sd

 

[sdoppke]

Would it be helpful if I posted pictures or linked an an example?

sd