Compiling identical cells from different workbooks

[aerolulu]

Good morning,

I've been struggling since yesterday while trying to take 8 cells in a 120 different workbooks and list their values on a single spreadsheet.

I have absolutely no knowledge on VBA but I've been thinking of learning how to use it for a while and that looked like a good opportunity.

I surfed and searched for that topic on many forums but could not find something I actually understood. Here is what I have in mind:

One sub that prompts the user to select a file (that will also allow me to store the name of the file somewhere as the names of the files are totally different).

Once I have the name of the file, 3 subs: one that opens the file, once that copy and paste the data of these 8 cells and one that close the file. I was thinking to paste on the same line as the one my cursor is in to avoid coding "paste on the next available line" even though that could probably be done.

I was able to do the first sub, the other ones are not working. I am not sure that I'm actually using the right method so any help would be highly appreciated

Thanks!