Hi all,

I am trying to make a document repository with the following features:
i. Documents are categorized in different worksheets
ii. Each worksheet holding these documents show the date when each document was last reviewed, next review date, author and owner
iii.There is a column which shows status of these documents (green=if reviewed within 360 days from today's date, red=if not reviewed within 360 days from today's date)

Problem:

I want to make a scorecard which pulls status data from each worksheet and then presents them a pie-chart. I am not being able to figure out how will I be able to get the data from each worksheet and then collate it to show the total number of documents with status Green and Red.

Kindly let me know if anyone can help me out with this.
Regards,
Neo