HELP! Consolidating Multiple Workbooks into One - the easiest way

[usui]

Hi Guys,

I would to ask a suggestion if what is the easiest way to consolidate multiple workbooks into one without using Ablebits function.
Is it possible to have a code for macro on this? or is there another way?

Need your help on this for work related concern.

The faster the easier, the better.

 

[COwen]

Can you share more information?

 

[usui]

Can you share more information?

i have multiple workbooks and with multiple tabs, what i want to do is consolidate into one workbook with separating the all the tabs