thanks for the reply, i dont think i have made myself very clear.

i have a source sheet which data gets inputted into daily...i would
like to manually copy the data to 7 additional spreadsheets within the
workbook. the 7 additional spreadsheets are called Monday, Tuesday and
so on.

the data columns range from E to AR