Suppose Sheet 1 looks like this:

1 2340 Cash Received Payment 2,000
3578 Accounts Pay Received Payment 2,000

2 4590 Expense Pd. Rent 9,000
2340 Cash Pd. Rent
9,000

Now, on Sheet 2 I want all of the information to be categorized by the
account number (ex. 2340)

How do I do this????