Filter a Dynamic list

[darkartist]

I am using sheet 2 to pull data out of sheet 1.

A9 has this formula in it:
=(INDEX(sheet1!$G$9:$G$7000,MATCH(0,INDEX(COUNTIF($A$8:A8,sheet1!$G$9:$G$7000),0,0),0))
(it looks through column G and takes out duplicates and blanks)

B9 has this formula:
=IF(MAX(IF($A9=sheet1!G:G,sheet1!E:E))=MIN(IF($A9=sheet1!G:G,sheet1!E:E)),"Only 1 Entry",MAX(IF($A9=sheet1!G:G,sheet1!E:E))-MIN(IF($A9=sheet1!G:G,sheet1!E:E)))
(this one looks in column A on sheet2 then looks up dates, Min and Max on Sheet1 to determine how old a certain item is)

C9 has this formula:
=SUMIF(sheet1!$G$9:$G$7000,A9,sheet1!$B$9:$B$7000)
(this on looks as column A in sheet 2 and references sheet1 to add up hours)

The problem is that if I sort Column C on sheet2 nothing changes. I think because as it tries to filter it the dynamic formula is reordering it back to what it was. Basically no matter how you try and filter it it stays the same.

How can I filter Column C or even B and others with this dynamic formulas that are in place?

Thank you.

 

[darkartist]

Maybe instead of having the formula in column a of sheet 2, that dynamically creates a list i should do it with VBA, so the list is more static and can be sorted? How might I do the same thing with VBA and would that work to help sort?