I am creating a spreadsheet for other people to use in which they fill in an
overview page which then feeds into 5 other sheets.

Which sheet the data feeds into is specified by a single column but all the
data around 60 columns needs to also be copied across to the the other
sheets. I would prefer not to do lots of if statements as this would slow
down the speed of the computer the users will be working on.

Finally if this is possible and requires a macro I would like it to run
automatically and not involve the user clicking on a button or equivalent.

Is any of this possible, a huge thank you to anyone who can help.