Using Applescript in Excel

I wonder if anyone can help me, I have an excel spread sheet which has four sheets. The first is a master and the other three contain only parts of the information from it.

What I want to create is a piece of script which will copy the relevant information from the first sheet into the following three, format the cells as they are in the first sheet with font, size colour etc and hide any row with cells that have no contents.

I have been playing around with the Script Editor for some time and reading things on forums but with no success.

Any help would be greatly appreciated.