Hello everyone,

I am looking to build a macro that goes through all the excel files (and their tabs) in a folder and pull out numbers which start with 01 or 02 and copy paste it into a new excel sheet.

I want it to go through those sale excel files (and their tabs) and pull out text in a certain font colour and paste that in a new excel sheet.

NOTE: The text and numbers are in text box and not cells.

Could someone kindly point me in the right direction on how I can go about doing this?

Thank you