Help with data integration

I'm not sure if I'm posting this question at right place.

Attached is a calender project which I'm working on. Sheet 1 has all data; Other sheets have calender. I would like to integrate data into the calendar (Basically I'm trying to track payment alerts in a calender view to make life easy). Can any one help me or advise me a solution.

Thanks,

Fareed S.

run the macro and tell me if I am on the right track

Dear RCM,

Thanks for your response; I've checked yours file and its pulling data only from one record.

Actually my requirement is as below;

Data needs to be pulled to calendar only if account(Column H) is open.
It should also pull data from all users on the sheet.

I've attached one manually typed example(See Jan) for your reference. Is it possible to automate it. Cell should display data from all open accounts on particular date.

Thanks for your time.

Fareed