Formula

[Carlisle]

I have a main spreadsheet (A) that has a column with information
missing, but this information is in one of four other spreadsheets
(B-E) that I need to extract and place in spreadsheet (A). I need this
formula to check all 4 spreadsheets for this data and if it is in one,
place that value in spreadsheet (A). I have information in spreadsheet
(A) say column e, f and c that is also in spreadsheets (B-E) to verify
that the value in (B-E) would be correct and then place that value in
the column in spreadsheet (A). I hope I am making myself clear, and if
not... sorry