I have several woksheets in a workbook that have differing data - Words
letter and numbers. I would like to create a summary sheet. I have worked out
how to get the data into the summary sheet. However the sheets have all been
renamed so i must insert every formula manually. Is there anyway for excel to
auto generate the formula for every sheet in the workbook?