I cannot seem to find an answer to this anywhere so hoping someone can help.

I have an excel sheet for planning my workouts. In my sheet named Data, I have 10 lists of different exercises for each muscle group. Then on my week 1 sheet I have a section where you can select the muscle group from a drop-down using the data validation =Data!$B$5:$K$5 Then the cell next to it is where you select the exercise so I use the data validation of =INDIRECT(A1)

The issue is I want to be able to add to the exercises. I have tried using the following formula for the named range

=OFFSET(Data!$F$6,0,0,COUNTA(Data!$F$6:$F$100),0)

I know from looking on Google that Indirect and Offset or Index do not work well together.

Any ideas for a workaround?