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: 1.) The text and numbers are in text box and not cells. 2.) There is a password prompt at the start and option for 'Read-Only' - the macro needs to click that to access file Thank you