Hi Dave, thanks so much for getting back to me!

I seem to be having a problem the file path location, the workbook I'm trying to extract data from is a macro-enabled file would this be an issue?