Is it possible to merge/append the contents of one worksheet to the end of another sheet using VBA/Macro - while both the sheets are in different files?
It is possible. You would have to copy data from one sheet and using Activecell.offset(1,0) and Xldown utility you have to paste them below the existing data
Also, by using Activecell.offset(0,1) & Xlright you can move right to merge.
Will send you some sample macro soon. I do not have them right now.