macro to extract info and paste to a new sheet

I need to write a macro for the following:
I have a workbook that will have anywhere from 1 to 30 sheets that will have
data in them. Each sheet will have a variable number of rows but if there is
data, it will be in columns A:S. The first row of data will be 12. Not all
cells will contain data however column C will always have a value (if there
is data in other cells for that row).
I want to be able to automate copying the data from each of these numbered
sheets into a new sheet called "Master".

Any help is appreciated.
Thanks,
Brad K

Try this Brad
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Brad K." <BradK@discussions.microsoft.com> wrote in message news:E807C5E8-6CC8-4DFC-B5A5-37C7F695C70F@microsoft.com...
>I need to write a macro for the following:
> I have a workbook that will have anywhere from 1 to 30 sheets that will have
> data in them. Each sheet will have a variable number of rows but if there is
> data, it will be in columns A:S. The first row of data will be 12. Not all
> cells will contain data however column C will always have a value (if there
> is data in other cells for that row).
> I want to be able to automate copying the data from each of these numbered
> sheets into a new sheet called "Master".
>
> Any help is appreciated.
> Thanks,
> Brad K