Hello Excel Guru's

I have an excel spreadsheet consisting of 3 worksheets

- Insert from Program
- Insert from Extract
- Formulas
- Result

The "Insert"'s worksheets will be public, meaning people would be able to either manually insert text into the cells/columns/rows or copy/paste in cells/columns/rows.
"Insert from Program" and "Insert from Extract" are two excel spreadsheet which will contain information most likely pasted in them from two other separate spreadsheets.

The "Formulas" worksheet will be private/locked/hidden, meaning this worksheet will take information from the "Insert" worksheet, specific columns and paste them in the "Formulas" worksheet, after the results of the calculations have been made in the "Formulas" worksheet, to then take only the VALUES and paste them in the "Result" worksheet.
"Formulas" will contain the calculation for comparison from "Insert from Program" and "Insert from Extract". I already have the formulas that I would need to use.

=IF(ISNUMBER(FIND("1",M25)),InsertFromExtract!K635, "Not OK")
or something along those lines
It would have to take Columns A, C, D, F, H from "Insert from Program" and Columns B, E, G, I from "Insert from Extract" and be placed in Columns A, B, C, D, E, F, G, H, I
This spreadsheet will be used by several people that is why I need to have a LOCKED/HIDDEN spreadsheet with the actual formulas.

The "Results" worksheet will be public and should contain specific columns from the "Formulas" worksheet which will contain the actual calculation results, Columns J, K, L, M from the "Formulas" worksheet and ONLY the VALUES to be pasted into Columns A, B, C, D in the "Results" worksheet.

Please help me guys because my knowledge of VBS is none unfortunately.

Thanks in advance guru's