How to merge or combine lots of excel documents?

[Wheatlyos]

Is there any way to merge/combine data from multiple unsaved excel documents so its neatly in one document? Essentially I have lots of excel tabs open (all unsaved) and want to take columns A1-A20 and B1-B20 of all excels and place into one main document going downwards. SO rather than have heaps of different tabs with the information, there will be one ‘master’ document with all the info. So the master document could be book 1 or any other named excel.
Anyone have any idea how to go about this?
A lot of methods I’ve found involve saved files and it’d take hours to manually save them. I know you can add macros to templates upon opening/creating files, however I have no idea how you’d auto save each document opened and give it a different name.
If description inadequate -
https://www.dropbox.com/s/0opi8pyy095hsrb/Book1 as per image.xlsx?dl=0


https://www.dropbox.com/s/q4d3g526zgbwrl4/Book 1 image.png?dl=0

 

[oldbrewer]

if you had a macro that could be used in any excel sheet ie a personal macro, that could save A1:B20 of the current sheet, open your master document, paste in the selection, then return to your current sheet.............move to next tab and repeat.....would this work for you