Dynnamic lookup across multiple sheets

[abz2786]

I am setting an internal client influencer tracker and am trying to create a 'main sheet' so i can see the information i need to extract at any given time.

I am trying to pull through the below on the main sheet but am stuck how to best do this as the information i need is dependent on the criteria from different worksheets.

i have attached a link to the document below

Client Influencer Tracker.xlsm

Shared with Dropbox

www.dropbox.com

 

[abz2786]

I needed this done for a meeting tomorrow afternoon so would appreciate any help if possible

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Dynamic Lookup code
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.