I have used the following formula(s) to copy the data to the master sheet...unfortunately this is unsorted, and the built in sort in Excel seems unable to do the sort...still working on it, but I think I will call in some help here....:
Formula: copy to clipboard 
in A2:



=IF(ROWS($A$2:$A2)<=ROWS(Table1),RIGHT(CELL("filename",ODC!$A$1),LEN(CELL("filename",ODC!$A$1))-FIND("]",CELL("filename",ODC!$A$1))),IF(ROWS($A$2:$A2)<=ROWS(Table1)+ROWS(Table13),RIGHT(CELL("filename",Labor!$A$1),LEN(CELL("filename",Labor!$A$1))-FIND("]",CELL("filename",Labor!$A$1))),""))



Dragged down (sheet the information came from..rename sheet and the return is still right)



In B2:

=IF(ROWS($A$2:$A2)<=ROWS(Table1),OFFSET(INDIRECT(CELL("address",Table1)),ROWS($B$2:$B2)-1,COLUMN()-2),IF(ROWS($A$2:$A2)<=ROWS(Table1)+ROWS(Table13),OFFSET(INDIRECT(CELL("address",Table13)),ROWS($B$2:$B2)-ROWS(Table13)-1,COLUMN()-2),""))

(This is the actual data transfer)



Dragged down and across

These will transfer all the information to the sheet you use them in..but everything I have so far tried will not sort them...yet !