Merge Data From Multiple Workbooks Stacking Data Into Master Workbook

I have three source workbooks that needed to be consolidated into a master workbook pasting the data with values & formatting.

The Master workbook also contains 6 additional worksheets that link to the data pulled in from the source files.
My question is how do I write the code so the source files populate the master in a specific order.
For example, the 3 source files are named "Central" "NED" and "WEST" and I need them to populate the master workbook in that order.

This is the code I am using to consolidate the data:

Option Explicit
Sub ConsolidateSheetsFromWorkbooks()
'Author: Jennifer Starr
'Date: 7/12/2013
'Summary: Open all files in a folder and merge data (stacked) on all

[Code] .....