One of the most common tasks Hector Garcia performs for his clients is consolidating or combining multiple QuickBooks files to create a combined set of financial statements.
That's because most of his clients have QuickBooks Enterprise, and that feature is built-in.
See what Garcia, the QuickBooks Trainer for Quick Bookkeeping & Accounting, has to say about the process here.