How to get Data from multiple worksheets & put them on one worksheet

This is my first post so please bare with me.
I've attached a copy of my workbook so you can what I am trying to do.

I have seperate "Expenses" & "Income" sheets for each month and I want to pick out just the Cheques from the expenses sheets,
together with the Date, Descripton, Cheque (amount) and Cheque # (number) and display them on a seperat worksheet.
This would make it easy for me to see at a glance what cheques have been written.
I've used "IF" statment but as you can see, it displays 0's and an odd date in the blank cells

Any help would be appreciated.

Thanks Richard,
I will try and do it now while I have only a few figures to put in.

I agree with Richard here - you need a single flat file to capture everything. Don't have income and expenses on different sheets - have them on one "AllData" sheet, with an extra column with either "Income" or "Expense" as the value.
Also, don't separate your data into monthly blocks (like you have on your Jan, Feb etc sheets) - this goes in the "AllData" sheet, with a date column.
I would imagine that pivot tables would be great for sorting your data out, so you CAN add calculated columns to your data sheet (especially useful if you are using Excel 2010 or above, with data tables).
Using this approach also makes data entry much, much easier.

Regards,

OM1950

Oh - and my OCD kicked in reading your sheet - you have a lot of spelling errors (January and Jauary for instance). This can end up making data entry and formulas difficult to write.

OM1950

Thanks OM1950, I'm redoing the workbook and will take onboard all you guys have said... and thanks for pointing out my spelling errors, I did not pick up on them

Hi. I've made a test workbook and put in everything I think we will need but can't seem to get the pivot table to display correctly.
It shows the Date,Amount,Cheque Number and the Description, which is what I wanted but not on the same row.
I've played about with the Design Tabe and this is the closest I've got

Thanks again Richard. I think I'm getting my head round things now