Hello All

I have a workbook that contains about 240 worksheets and a summary worksheet
and I need to copy over totals from each of the individual worksheets into
the summary sheet. For example I need to use cell B1 for each of the sheets
and enter it into column 2 of the summary sheet (this would go down 240 rows,
one for each worksheet). Instead of having to write a formula for each of the
240 rows, is there a way I could enter the formula for the first few rows and
copy (or drag) the formula down for the rest of the rows where the tab number
will change automatically?

Thanks.