I need to copy O1:O4 in multiple workbooks in a certain folder; the names of these workbooks are stored in the variable FileList, and also, pasted in row one of the sheet. How would I open each file, extract the data, and copy the file into the sheet that was previously opened (named "Money").
Thanks.