Copy specific values to another and comparing it with another column to change the color.

Dear All

I am trying to create a macro to copy certain values from one sheet to another sheet in specific location. Please find the attached sheet for reference
Steps for automation: Please open the attached document to understand better.
1) In the attached document from LPS sheet I need to copy the headers (Range C:S) to another sheet named “performance test”. In performance test I need to paste those values in the range (A7:A14) under transaction name.
2) Then I need to copy specific 90% values Response time (Range: E97, G97, I97, K97, M97, O97, Q97, S97) to performance test sheet (Range: L7 to L14). We need to copy only the values of E97:S97 to L7:L14 not the formula. The going to be copied values is not in continuous range.
3) Finally in the Performance test sheet the copied value (L7:L14) will be compared to the previous column (k7:k14) and if the difference is positive then the value in the copied cell should change the color to amber.
4) In the document in sheet1, I just want to give input for copy target cells and paste target cells so that the copied values can be pasted wherever I want. Also the target compared value cell in sheet1 as input.

Your help will be much appreciated.

Thanks
Muthu