Pulling Data From Multiple Different Workouts into One Workbook

Hey guys-

I'm pretty new to VBA (read: have used it once two years ago), but I think it might help in this situation. Basically I have 3 completely different spreadsheets and I want to merge everything into one spreadsheet. For instance, the first spreadsheet would be columns A-D in the master spreadsheet, the second columns E-J, and so on and so forth. Any help would be greatly appreciated, I've been trying to find something that would work for hours but I figured maybe it's over my head.

Thanks in advance.

Some additional details: I have all three Excel sheets to be merged saved on a folder on my desktop.