VBA - Copy data from multiple workbooks into one workbook.

[l KAUTION l]

I have about five different workbooks. I need to copy data from all of them and put it in one main workbook. The data needs to be all on one sheet. Then I need to sort the main workbook by cell b6.

I have no idea how do to code in Excel. Any help would be wonderful.

I searched and found how to copy multiple workbooks from a folder to multiple sheets in a main workbook but that was all.

 

[l KAUTION l]

Nevermind. I was just told that I no longer need to do this. If someone wants to respond to this, go ahead, I'm sure a future searcher would appreciate it.

Thanks