thanks for the reply! the master sheet "Day" contains all of my
data/the data is apended to it....then I want the additional 7
worksheets to contain information depending on day e.g. monday, tuesday
etc...the data is naturally copied from the master sheet.