Using data from Multiple Objects

Hi,

I'm having multiple Excel files 'Embeeded as Object' into single excel file, I'm trying summarize by extracting / link data into one file.

My problem is I'm unable to link Object data into my worksheets. Link breaks in even of change of opening sequence of Objects.

I want that links are created as '[OBJECT1]Des'!A2 instead of  '[Worksheet in Test.xlsx]Des'!A2.

Many thanks in Advance.