Using several datasheet to generate a form

Hi,

I'm trying to combine and rearrange information from several datasheet into one sheet as database and try to generate a form according to the database sheet.

From the attached file, what I currently have are Sheet'IT', Sheet'Maintainance', Sheet'FC Database'

First, I want to combine 'IT' and 'Maintainance' in a format in 'ALL'. is there any way I can do that? It can be more than one step.

Second, I would like to generate a Form like the one in 'Table' using combination of information from 'ALL' and 'FC Database'.

1. according to 'ALL', we have 17 FC but Mr.Adam the Facility & Equipment Manager only have 5 FC which is FC007, FC019,FC033,FC050 and FC058. So, how can I generate a table that only contain the specific 5 FC for Facility & Equipment Manager?

(the last form I did, there're only 10 FC and everyone have 10 FC, so I just have to use vlookup)

2. how to vlookup for sheet'table' B9:B12 by using information from sheet'table' A8 and C8 to vlookup in sheet'FC Database'

3. is 'FC Database' design and layout accommodate the vlookup? should I change or adjust, or please suggest the ideal database format?

I know I could break down all the question but I thought that this is a question of database design as much as asking about the excel formula, so , I want to make sure that everything is in the file.

Please tell me if there's anything I should do to make it easier for you to help me.

Thank you so much