On Aug 7, 11:49 am, daughteroflight
wrote:
I have 30 worksheets within a workbook, and want to summarize the information
found on them on the front worksheet. However, when I open the workbook, I
will only plug numbers into about 5 of the worksheets. And I want only the
information on those five worksheets to summarize on the front sheet. HELP!
:-)

If you want specific help, you'll have to give specific info here.
Otherwise, there's really no way to say anything. Maybe start with
questions like these:

Are the 30 sheets all the same? What's the same? What's different?
What kind of summarizing? Adding? Counting? Listing data?
Why are there 30 if you only need 5 at once?
Are you keeping the data in there and adding to it each time? Or is it
kept blank and you just put in all new data each time?
What formulas do you already have? What isn't working?