I am using excel for project management. I would like the ability to bring
data from multiple sheets to the summary page. For example, I would like the
ability to find out, on demand with just a click, all the tasks that a
particular person is working on from multiple sheets. Can anyone please
let me know how best to resolve this? Thanks much!

You can resolve it by turning your thinking around. Don't use multiple sheets: use one data base,
where all the information is entered into a table, and then create the reports from that using
filters, pivot tables, or formulas that extract specific information. Just because you can use
multiple sheets does not mean it is a good idea in all cases.

HTH,
Bernie
MS Excel MVP


"ExcelRookie" wrote in message
...
I am using excel for project management. I would like the ability to bring
data from multiple sheets to the summary page. For example, I would like the
ability to find out, on demand with just a click, all the tasks that a
particular person is working on from multiple sheets. Can anyone please
let me know how best to resolve this? Thanks much!