Hi ,
I have a workbook wherein a set of data is there having same number of columns and same number of rows ( sort of template) in different work sheets, all i want is to consoidate the data in a Summary/Master Sheet wherein the Column heading appears in the first row and rest of the data underneath from differnt sheet until all the data is consolidated from all the different sheets.
Attached is the sample work-book with different worksheets and 'Result' required in sheet named Summary.
Any help is well appreciated and thanks in advance.
Many thanks
Bookmarks