Is it possible to split data from one worksheet to seperate worksheets based
on a criteria in Column A, e.g. day / month / surname / etc.

I have a master list of data which changes frequently and it is split into
seperate worksheets for individuals to review data specific to them. I want
to automate copying the data from the master schedule to the seperate
individual worksheets.

Thanks.
--
Richard