Referencing the correct object in a formula

I have macro that performs a reformat of a collection of sheets that are contained in a single workbook.

Please Login or Register  to view this content.

however the problem is with column F and this code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

instead of applying to each individual sheet the FirstSht is referring to the very first sheet in the workbook instead of carrying out the operation in each worksheet of the formula. How would I change this so that the first sheet index is not being used in all the subsequent sheets but rather the columns that are specified in the formula?

Maybe like this (completely untested):

Please Login or Register  to view this content.

That works perfectly: how do I put this part back in it?

Please Login or Register  to view this content.

Edit nvrmind:

have to change to

Please Login or Register  to view this content.

Thank you so very much for you valuable assistance shg