Merging Multiple Excel Sheets Into One Sheet

I have a workbook with multiple sheets (21 sheets) in it. The header on each sheet begins at row B5. The actual data starts from row B6. The number of rows in each sheet varies and the last row contains the total for all columns that has numbers. I wish to have one sheet that combines data from all the 21 sheets. But;

1) The header should be repeated only once
2) Only the rows that has data should be included, blank rows should be ignored
3) I do not need the last row i.e. total to be considered while merging the sheets

I've given a snapshot of the data below. The first column contains the row number just for reference.

B5 Name Address Telephone Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Total Other Members B6 Tony PQR Complex Road 1 12345678

300
500
800
B7 Stany PQR Complex Road 1 1234567890
1,000

[Code]...

[IMG]file:///C:/Users/DERICK%7E1.FER/AppData/Local/Temp/moz-screenshot.png[/IMG]