VBA to copy specific cells from all files in a folder

Thanks for your help Robert. Unfortunately this did not work either. So to make it less complicated I manually sorted out the files from the folder which did not have HOURS spreadsheet on it.