How do I collect data from many workbooks from select columns into a single
workbook automatically. I don't want to open each one manually and copy and
paste from it to the main workbook. The system should ask me for which file
to be opened.

Please can you help.

Thanks and regards,

Sandeep S.