VBA Code to copy data from one sheet and paste to multiple other sheets

In the attached file I have a macro that will copy the data entered in B3:F3 and paste it into a range below depending on what is selected in C4. This code works great, however I want to see if I can have a stand alone data entry sheet (Multi-Add) that when the button is clicked it will copy the data on that sheet and paste it into every other sheet in the work book but again based on the "Type" selected in C4.

The final thing I want to do is in the "General" and "Specialist" ranges - when there is no data in the row I would like the row to be hidden and then when data is added through the above it would un-hide.

Any help on this would be great, thank you.