Having an issue with variables across sheets

I spent the better part of the day trying to get this code to work. I was hoping someone could take a glance at it and point out what stupid mistake i've made.
My main problem is, I want to use my variable as a column reference but cannot seem to get it into the correct format to accept it as a variable. I spent a large portion of my time trying to find a solution online and it seems like whats called RC is what people use but I cannot seem to follow that style very well.

If I made a mistake posting this incorrectly or something to that nature, let me know and I will change it immediately. Sorry in advance I am new here

Please Login or Register  to view this content.

I left out some of the other parts of the code since the part im really stuck on is making the C a variable not a column reference.

Removed this since it was a useless post that added no value.