I NEED TO EXTRACT DATA FROM 3 DIFFERENT SHEETS FROM 150000 FILES ONTO A SINGLE NEW WORKBOOK.
FIRST SHEET IS 'INFO' I NEED 'B9' 'B11' AND 'C2'
SECOND SHEET IS 'fSC COMM' RANGE 'H9:H79'
THIRD IS 'PCF COMM' RANGE 'H15:H84'
THE MASTER WORKBOOK NEEDS TO HAVE THE FILE NAMES AS FIRST COLUMN AND EVERY...