It seemed to work fine with the sample workbook.

A new worksheet was created for each Area and the data for each Area was copied to the appropriate sheet.

What's different about the sheet you are trying it on?