how to show value form sheet1 b2 in sheet2 c2

hi

all

I want to show value from cell b2 on sheet 1 on sheet 2 cell c2 which I know is

=sheet2!c2

but if I filter any columns on sheet one the row's move up and show the filtered data now my problem is I want to show the value at the top of column c after data has been filter like a subtotal function
on sheet 2 cell c2

thanks in advance

shane

Hi
Sixthsense
that not really a option to me as the data in the workbook is exported from access to excel of which the sheet content is cleared and refreshed with new data from access

Cheers

Shane