Counting total quantity of entries from multiple tabs

[joshbrfc]

Hello,

Recently had some fantastic help from this community, so thanks all. I love excel, but at times we all get a bit stuck.

I have a sheet where I'm working on right first time.

This is my master data tab, where column B is calculating a number of entries from a column on each individuals tab:

Now what i want to auto populate is this:

I want row k of my 'master data' tab to auto collect entries matching that of the entry in column J.......... from column B on all of the tabs as a total.

 

[dermie_72]

how many tabs are we talking?

 

[joshbrfc]

how many tabs are we talking?

29 tabs. Sorry i missed a screenshot off in the OP, but it's basically tabs for all of those blacked out.

After "This is my master data tab, where column B is calculating a number of entries from a column on each individuals tab:" the below should have been in the OP.

 

[joshbrfc]

BUMP.

Any of you legends able top assist with this? I still haven't got a way forward