Excel 2007 : Get Data from Check List

[Annie Yap]

Hi,

I do building management and am required to do a check list which is suppose to help in checking as well as doing a to-do list and collect data as well.

Attached is a part of the check list which is similar to the rest.

In 1st worksheet(Toilet check list), i'll key in any cell a number. My management wants the number to be reflected in the tab its suppose to appear, with the description.

Could i know how this can be done with the layout of the checklist?

Appreciate your help. Thanks!