Selected Answer
To scratch the surface you might look at File > Options > Formulas > Workbook calculation. If you set this option to 'Manual' no calculation. The same setting is also available from the Ribbon's Formulas Tab in the Calculations section. There you will also found buttons to manually calculate either a single sheet or the entire workbook.
Look at File > Options > Advanced > When calculating this workbook. There are options for 'Update links to other workbooks' and 'Save external link values'. It seems that you might disable the update here and show static values instead. I haven't ever used these properties and recommend that you try them out.
The basic question is what do you want in the cells with the Vlookups to other worksheets instead of the looked-up values. If all you want are static values the best method should be to remove the links. This would have to be done column by column. After determining that the column shows the values you want, select all of the values, copy, Paste > Paste Values and all formulas are irretrievablky converted to the values they last calculated.