Hi guys,

Thanks for reading, I would really appreciate a hand with this! My question is as follows:

I am trying to put together an excel document which sounds quite simple but I really am new to all this an Im unsure of the best way to go. I dont really understand the abilities/constraints of macros/ pivot tables and consolidation etc etc.

The purpose of the document is to help my small business keep track of cheques that are going out and comming in so I can have an up to date idea of what should clear in the account today or at a chosen date, also against what is due to leave the account.

OK so, I have 1 sheet called "payments in" which has the payment reference, desc, date, expected clearance date and value.

The 2nd sheet is "payments out" which has the same fields.

My third sheet is where I am having problems- this is where I want to pull in the data from the other sheets to view in one list (sorted by expected clearance date). So, its a master sheet showing incoming and outgoing values, sorted by date (data from each sheet is therefore mixed) and this sheet should update whenever a new payment is added or an old one changed on the other sheets.

OK guys, so thats where i need the help- I need to know the best way to achieve this because its driving me up the wall!

From my research I was considering doing it backwards i.e. creating the master sheet and dynamically building the payments in and out sheets with pivot tables but it is essential that these are the entry points for clarity to the staff who will be entering the data (they are less skilled in this than me!!)

Thanks for reading this far! Any help is much appriciated....

Tony