Consolidate Data from Multiple Sheets into One Sheet using VBA in Excel :- By G Kumar
If you want to consolidate (combine) data from multiple Worksheets into a single "output" Worksheet in Excel. In this VBA tutorial it has been covered.
However if there is any query, plz comment.....