Merging two or more sheets in the same work book

[rtr1811]

Hi,
I've an excel file in which a few sheets are present. I've to copy the data in the sheets excluding the headers (Header is marked with Yellow Color in each sheet) to a format called Wardwise.
Please refer to the attached sheet.
I've to copy the data in Column B in the Sheet 98 to Column B in the Sheet in Wardwise. Then I've to copy and paste below the data in Column B in the Sheet 100 to Column B in the Sheet in Wardwise. Then I've to copy and paste below the data in Column B in the Sheet 101 to Column B in the Sheet in Wardwise.

Then I've to insert a column called Part and paste the sheet numbers (Name of the sheet). ie for the data in the sheet 98, 98 has to be pasted and for the data in the sheet 100, 100 has to be pasted and then for the data in the sheet 101, 101 has to be pasted.

Then remaining columns in each of the sheet has to be copied to the sheet Wardwise as it is.



Then the sheet Ward wise has to be sorted thorugh Columns D,C & B respectrively.