Tracking due dates of numerous worksheets

[jloudermilk]

Currently I am responsible for organizing a large amount of documents for my companies strategic planning cmte. A recent task has left me completely stumped. I use Excel on a daily basis but admit to not knowing it 100%. Here is what I am trying to do:

I have 15 different "action plans", the template has been created in excel, and each cmte mbr has completed their related action plan (filled in the blanks). I need to take each of these plans and monitor the due dates, person responsible, and completion dates.

Is it possible to have a "master" worksheet that will automatically update the needed info when I make changes to each individual action plan that will each be on an individual sheet (one action plan per sheet). My intention is to have all of this info in one excel book, to include 16 sheets (15 w/ an action plan, and a Master sheet)

I hope that have communicated this well, and I would appreciate any advice, my effectiveness on the job depends on it.

thanks, Jennifer Loudermilk

 

[BrianB]

Not sure exactly what level of knowledge you have. Let's start with the basics.

You can easily have a worksheet reflect changes in another.
1. Put your 15 sheets into 1 workbook.
2. Make a master sheet
3. click a cell in the master sheet and type = (equals sign).
4. Go to another sheet and click in a cell there.
5. Press enter key.

You end up with a formula like :-
=Sheet2!A1
when the cell will show whatever is in cell A1 of a worksheet called "sheet2".