help needed with excel 97

[sithlord3k]

I need help with a problem that I'm having. I've got about 300 sheets i
my excel workbook. I need to copy the data from cell B5 on ever
sheet,into a new sheet.
What can I do

 

[Anne Troy]

Copy to where? You may want to try something like this:
http://www.officearticles.com/excel/sum_the_same_cell_in_multiple_microsoft_excel_worksheets.htm
************
Anne Troy
www.OfficeArticles.com

 

[Bob Phillips]

i=1
For j = 1 To ActiveWorkbook.Worksheets.Count
If Worksheets(i).Name <> Activsheet.Name Then
Range("A" & i).Value = Worksheets(i).Range("B5").Value
End If
Next j