How to copy data from one worksheet to another

Donj01 - Apr 1, 2015 at 07:18 AM

I'm having the following problem,
I have made a file with two active worksheets.
Now I would like to copy the totals from worksheet1 into worksheet 2 automatically : normally I do this with sheet1!(cell position).. However , as on the first sheet there are hidden colums ( three per column on sheet2) excel Always takes the values from the hidden colums (sheet 1 as well). So only every fourth column on sheet 2 is correct.. How would I have to make the formula to only get the 1st,4th,8th total into sheet2?