Imagine for a moment that I have this agenda for a meeting. On the agenda,
there is a list of topics for discussion. Next to each topic, is a person's
name who is responsible for that discussion. Now imagine several agendas
that are similar in format, but from different dates. What I am trying to
gather is the data from all the agenda worksheets and summarize them into one
worksheet to show management who spoke what topic, and how many times did
they speak it. Management could go into each and every agenda and look the
information up, but they would prefer to just look at one spreadsheet summary
of all the data, and any new data that is added for future agendas. I don't
know where or how to begin consilidating this. Please help ASAP.