If I understand correctly you want to have data from another Workbook, but you would not like to have the "long" formula's in like (e.g.)
An option can be to use External Data from your other Workbook.HTML Code:
As it is a procedure I cannot show an example. Just tell me how the data you want to connect to looks like (Table, Spread over the entire workbook, ....)
Bookmarks