Follow this procedure:
Highlight the cells you want to copy ( for the moment it will include the hidden cells)
Then select EDIT
Go TO
Click on SPECIAL
Select VISIBLE CELLS ONLY
Select "Copy"
on your new worksheet select EDIT, PASTE SPECIAL
select "VALUES AND NUMBER FORMATS"
This should do it for you