Link a dynamic named range that contains non-adjacent columns of a bigger table, from Excel to Word

I have a large table with 20 columns in Excel, out of which I just need 4 columns to display in Word Document dynamically.

I first went to the Excel, created a Named Range, named as 'InitTechStatus' with the below formula.

=INDEX(Tbl_AllDetails[#All],SEQUENCE(ROWS(Tbl_AllDetails[#All])),{1,2,4,8})

I am able to use the range 'InitTechStatus' elsewhere in Excel. I am using Office 365 and the data spills over to the required number of cells from the cell in which I type my named range.

However, I am unable create a link in my Word Document to this named range. I used the following in Word Document to link to the Excel

{ LINK Excel.Sheet.12 "E:\ProjData\ProjStatus.xlsx" "Sheet2!InitTechStatus" \a \f 5 \h * MERGEFORMAT }

However, only data in the first cell of the range (that contains 4 columns and 30 rows) gets displayed in the Word document.

I have gone through different forums for a solution, but couldn't find one. Any solution / workaround shall be highly appreciated. Thanks.