Linking sheets in diff workbook & sheets using IF function or = function

I have two Spreadsheets, one with multiple worksheets and the other with one. Each worksheet has the same column fields just more rows.

example . Column A, Row 1 "Building", Column B, Row 1, "Floor" etc.

My second Spreadsheet has one worksheet that uses the same headers. What i am looking to do is link the columns of the first spreadsheet to the second using either the IF formula or the = formula.
i.e

If any information is entered in Column A, Row 1 "Building", in any of the worksheets in Spreadsheet one then return the contents entered. (Only one workseet will be used at a time in Spreadsheet 1). I don't know how to do multiple logical statements

I am using this spreadsheet for importing data into a database using csv format. The issue is multiple users and encountering typos. I have created a spreadsheet and use formulas to fill the cells vs someone cutting and pasting or filling and etc and locked it.
I am trying to eliminate them doing to much typing as well on the 2nd spreadsheet, so once they open it the formula will fill out the same fields.

Hope i am not too confusing. I can upload the spreadsheets if needed Thank you
KG

Hi qstorm

Welcome to the forum. To enable to help you better, please attach a sample workbook with dummy data and what you want in second worksheet.