Write a macro to consolidate data from sheets

Good day.
Need to write a macro for excel that would allow to combine in one sheet of the workbook data from an arbitrary number of sheets of different workbooks.
The following conditions:
1. When you run the macro should be able to SEL