Have you considered creating  the pivot table  directly, using multiple data
ranges (your bank account data  sheets)? Depending on the layout of your data, it
may not be necessary to combine the data before creating the pivot  table.