Good evening,

i am attempting to create a VBA macro that will add various formulas to columns and am wondering if it is possible to use the worksheets function in the formula instead of a specific sheet name. My thinking is, I would want the macro to run even if the end user were to change the name of the worksheet. Below is my formula. Is it possible to replace Sheet1 with worksheets(2)?

=INDEX(Sheet1!$S$3:$S$6887,MATCH(E61,Sheet1!$B$3:$B$6887,0))

Thanks.