macro: when row in inserted in sheet 1 a row is inserted into other sheets copying formula

hello! if anybody can help me with this i would be very very grateful as i have been struggling with it for a couple of weeks with it now!!

Basically i have a workbook of 17 sheets. I'm looking for a macro that inserts a row into all other sheets when it is inserted into (preferably) sheet 1 (but whichever is fine!). When sheets are inserted i would like for all the formulas in each sheet to copy down the different formulas. the employee names are in column 2 of 2014 total, and each sheet copies the text... i dont mind copying over the names to each other sheet, but for this book to be used by others i need it to be as easy as poss!!!

I have attached the workbook... please let me know if anybody can help at all or if its not possible!!!!!

Really appreciate any answers or comments!!!

niamh

I need a macro to do it automatically... I wont be using this workbook myself and i'm just looking for the right code. any ideas?

what type of button? any way is fine but what type do you mean?

i want that the user can insert a row anywhere in the first sheet and then that row will follow, or be inserted, throughout the whole workbook at the same place and copy down formulas.