Transferring data from master sheet to slave sheets

BSB

i think i am now taking the mick lol,

I am struggling with the following.

1. I cannot get the distribution macro to distribute without deleting workings and overview sheets

2. the automatic update macro when I change the category has an error message.

3. the two buttons I added to auto sort alphabetic and date order, it only works to where I have set it (example ser 700 ish), is there a way it can check the sheet and if the cells are filled in then it sorts it

4 . the add new line, can you make so it sorts out the ser 1,2,3,4 etc in left hand column.