Sounds like it is time to start learnign Access. In the meantime, look at
this:
http://www.rondebruin.nl/copy2.htm
The code there will allow you to merge data from all 50 sheets into one
Summary Sheet, which Ron named 'RDBMergeSheet'. Then, you can do things like
filter, sort, and/or build a Pivot Table, which will help you organize you
data from those 50 Sheets. One caution about Pivot Tables, you must have a
header and all data under the header must be of the same type, or you'll get
screwed up big time.
this is a good example:
http://peltiertech.com/WordPress/regular-charts-from-pivot-tables/
Good luck,
Ryan---
