"JC" wrote:
.. I have 1 workbook with data pertaining to different managers
Want to make different worksheets for different planners..

Perhaps one way ..

Try this previous response to a similar query:
http://tinyurl.com/kwsgw

A new link to the sample construct therein is at:
http://cjoint.com/?cwlqnxXxgn
AutoSortData_BySheetName.xls

(previous link to sample expired)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---