Create a macro to open workbooks

Hello,

Please help me to create a macro which will help me to open different excel workbooks and copy particular data/ figures from excel sheets to a new workbook m.

I have around 45-50 excel workbook with 3-5 sheets in each workbook.

Each workbook is named as different unique number such as 823456,823731...etc. All the excel sheets inside workbook is named as same as VOR, Customer Copy, etc..

I want to create a macro which will help me to open each workbook and will copy figures and paste in another excel workbook.

Is it possible!? What details we need more !!!