copy same range (A:AC) from all visible sheet to master sheet (EXCEL 2010)

[deekar]

I can't seem to find a macro to do what I need.

I have several worksheets of data in a workbook.

Each work sheet uses the same header info (row A1, cells A:AC)

I need to create a master sheet of the VISIBLE worksheets data
Rows A2 on for each sheet so I don' have to delete multiple column titles.

And to "update" the master OR "delete and recreate the master" when the sheets are updated or edited

can anyone help? Thank you

I use 2010