Dear Latha,
We the members of this forum are outsiders and we do not know anything about the nature of your business and expectations of your MD. If you are Executive Assistant and report to MD or CEO, then it is his duty to provide the format for the report. Therefore, you may sit with him some time and understand his expectations.
As far as reports are concerned, some of the information has to come from the HODs also. Therefore, MD must issue a circular on what information he wants from them, when he wants, how he wants etc. You might be the person to compile the information to provide in tabulated format.
Thanks,
Dinesh Divekar