Hi kingcordova,

Your best bet is to use multiple consolidation ranges. I think the headers need to be the same between both. Read about them at:
http://support.microsoft.com/kb/213947
http://ddalgleish.hubpages.com/hub/C...ultiple-Sheets