Attached is a copy of your workbook with the code added and the sheet code name adjusted to reference the correct sheet containing the subject codes.

I think you would be much better served by using a *SINGLE* worksheet to contain all of the data and include an extra column for the date (month year). Assuming you will be entering grades or other data you may want to report on, a single sheet will make this task much easier. In addition, the code only needs to go into the one sheet module, otherwise you will have to add it to all sheet modules as you add new sheets.

I've add the code to the two worksheets in your sample workbook.

In Excel 2007+, when you have macros you *MUST* save the file as a .xlsm file type, otherwise Excel will delete the code from the workbook.

Excel Help_840513.xlsm