consolidate multiple worksheets

I need to consoildate mutliple worksheets in a workbook. Sheets 1 & 2 need to be left out of the consolidation. I also will be constantly changing information in the worksheets being consolidated and need excel to update at the same time. I also need the new worksheet to be hidden. Does anyone know of a macro that will do this? I don't need data from one sheet added to another. One sheet will not affect another. All I need is a macro that will copy word for word and number for number what is in sheet 3. Once it comes to the end of the information to begin copying what is in Sheet 4 and so on.