Hello,

**Is there an Excel formula (or formulas) which will merge data from multiple worksheets into a single summary worksheet and keep the combined rows sorted?**
For example, suppose you have three checking accounts, each with identical column headings and each occupying a separate worksheet as shown here:

Note that in this screenshot:

• each colored worksheet tab is named named by the last 4 digits of its account number

• the account for each transaction is identified by the same 4 digit code in column B

• the transactions in each account are sorted by date

I'm looking for an Excel formula that will capture the transactions from all three accounts and combine them into a single summary worksheet as follows:

In this screenshot, note that:

• each transaction is still labeled by its respective account number in column B

• the transactions are in chronological order

• the balance shown in column G is a combination of all three accounts

I'm hoping there is a solution which will populate the Combined worksheet automatically and which involves only Excel formulas since that will make them tweak-able for me. The 2nd option is to use VBA but then I will be dependent on EE for changes. I prefer not to use an Excel add-on since I've found them to usually be un-tweak-able.

Thanks a bunch

File attached:

Combined-Accts_EE.xlsm