We have massive amounts of information from multiple sources of workbooks
that we need to update constantly on our Excel reports. To make things flow
faster, I set up vlookup, hlookup, with if(isna...) statements.
Unfortunately, my boss and her bosses did not find it intuitive because they
want all the links to point to particular cells directly without formulae
that reference an array of data. For me it will be a long nightmare to link
every cell in my reports to every cell in many different workbooks.

Any suggestions to make this easier? Thank you for your comments.