Populate multiple tabs based on input in Master tab?

Hi,

I'm not sure what to use to populate multiple tabs based on information inputted into one tab. I think possibly an array?

On the attached example I need all data for each Company to be pulled from the Master and populated in the appropriate tab. Essentially the end result is the master is populated and the other tabs automatically populate themselves.

Is it possible?