Concatenate dragging formula down problem

So I have a formula like this:
=IF(AND(((INDIRECT(CONCATENATE("'",A$1,"'")))>(INDIRECT(CONCATENATE("'",A$1,"'", "!$K4")))),((INDIRECT(CONCATENATE("'",A$1,"'", "!$K5")))>(INDIRECT(CONCATENATE("'",A$1,"'", "!$K6"))))),(INDIRECT(CONCATENATE("'",A$1,"'", "!$K5"))),"")

It works however when I drag it down I want the 'K' value to increase by 1 row. For example when i drag the formula down, i want K4 to be K5 for the formula in the next cell. Right now, when i drag it down, the cell value does not change because it's in "". Can anyone help fix this?

Thanks!

like this K4 will increase

Please Login or Register  to view this content.

kind regards
Leo