Creating Macro to create new worksheets and prefill some data

[hotshot24]

I am working on cleaning up an estimating spreadsheet. I want to be able to do a couple things.

1) Hide Rows with no value in column 'E' from rows 5-108

2) Hide Columns with no value from column 'E' : Rows 5-108

The 2nd part is that I want to the macro to check for a value in Column 'E' from rows 5-108, if there is a value there then I want to create a new worksheet just like 'Sheet 2'.

In that new worksheet 'Sheet2' , for an item in row 5 I want to

1) place value from "Sheet1" cell C5, into 'Sheet2' E17.
2) place value from "Sheet1" cell D5, into 'Sheet2' E31.
3) place value from "Sheet1" cell H5, into 'Sheet2' A11.

Any help would be much appreciated.