arrange complex excel data from different worksheet and sort into one database

Hi, I have a data sheet from various department which in the same formate but different information which I want to arrange everything in on worksheet so that I can see the common used information.

In sheet 1, colum M,N,O are data of FC001,FC003,FC005

In sheet 2, colum M,N,O are data of FC002,FC004,FC005

I want to display information like in Sheet 3 where the FCs are sorted.

Has anyone suggest any best way to do it? Though not fully automated but at least, not by hand because in reality, There are 88 FCs and 200 positions!

any suggestion at all is appreciated!

or at least say something like 'No way! u gotta do manual!' , then I can give up peacefully.

Thanks!


Book1.xlsx