Linking Dynamic Excel Ranges in Word

Hi There,
I am troubled with populating data in a word document based on a range of data in my Excel sheet, as my data range varies so I can not use the mailing list option.
I have a range with a fixed number of columns but a variable row number, which comes from selected checkboxes by the user. The problem is when I copy the range in Excel and paste special in the word document, the row number is fixed to the number selected originally in Excel. Even with updating the link in the word document, it won't be changed.

I made and named a dynamic range in Excel but I don't know how and if I can use it in a word document.

NB: My Excel workbook has several sheets so I can not use the link option.

Could you kindly please help me to solve the mentioned problem?

I do appreciate your time and help in advance.

Regards,
Farshid

I'm not quite sure what you mean, can you attach some example files showing the problem?