Hello,

I'm striving to program a macro. I'm a total newbie so I'm always stuck somewhere...

I will collect a lot of files, all of which contain some data into a certain cell or range of cells which will not be named (no named range). The cells are always the same ones for each file. This file will be protected (don't know if it's relevant...).

What I want to do is to program a macro on a separate workbook, which will collect data from all of those files (maybe creating a pop-up window "Open" where I can select multiple files) and then past them into a table.

How can I do so?

THANKS!