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.)

HTML Code: 
An option can be to use External Data from your other Workbook.
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, ....)