in reply to Re^2: Not able to create worksheets inside a subroutine
in thread Not able to create worksheets inside a subroutine

Please add use strict; at the beginning and correct all errors that will be thrown. Also, the single quotes around $Month will prevent that you get the correct month. You also lack a dot in front of the extension xls.