My data is larger than one excel worksheet is capable of so I have split it
by months. It has already been summarized as much as I can.

Can I use two or mor large excel worksheets to create one pivot table?