Fetch data from specific cells of 2 different sheets and paste to particular cells of new sheet

2A

This is the sheet (hence forth 2A) is required to be filled automatically

ie, from these two sample sheets

2B

2C

here 2B is the reference sheet only, I will enter 2B details in 2C - E4 & E5 column in the corresponding rows, suppose in 2C- SN. 1 is the details for 2B cloumn A - I and column B -category 1 , then i will write into 2C - E4 as I & E5 as 1,

likewise i will assign applicable numbers, if the formula detects entry in E4 & E5 it should look for the data entered in E4 & E5 and copy the corresponding description from 2B and paste into 2A failure Description, also from 2C it should take description from 2C and paste into 2A failure investigation and action taken, likewise so many cells are to be copied from 2C to 2A, anyway this should account all the repeating entries also ie,if in 2C 5 rows are having E4 -I and E5-2 then it should make 5 different entries in 2A (but all 5 will have same description from 2B)

this should go on until all the entries of corresponding data ie, E4 - I & E5 -1 is completed, then it  should look for E4 - I & E5 - 2, if E4-I & E5 -2 is not available it should jump to E4-I & E5-3 and so on, upto available data from 2B (ie, if 2B A-I is having only B-1 , B-2 & B-3 it should stop looking once after copying all E4-I, E5-3, then go for E4-II & E5-1 & so on)

Can anybody help on this because 2C is a very big sheet and scroling and copying data takes a lot of time (days exactly) for a month data.