application.GetOpenfileName

provides the file open dialog to select a file.

it returns a fully qualified file name which can be used to open the file
and copy the data.

You can put this in a loop and when the user clicks cancel, you can stop the
loop
--
Regards,
Tom Ogilvy


"uriel78" wrote in message
...
I've got several workbooks; in each workbook there are 4 sheets whose name
is the same for ale the workbooks (call'em sheet1,2,3,4).
In each sheets there are equally organized data (only values change form
one
sheet to another)

In a new workbook ("summary") I wish I could have a macro that ask me to
choose a workbook (maybe without opening it), pick up and copy data in
sheet1 and paste in summary workbook. After doing this operation, I'd qant
to be prompt if select another file to do the same operation (choose
workbook, sheet, data ,copy& paste)...

Is it possible...?