Strategy advice sought, managing a 8 sheet ods

[Wanderer]

@clear

I need to figure out how to safe guard the all-in-one sheet from errant key strokes, yet still allow single cells to be toggled in and out of editability.

Read about

• data validity in Calc
• protecting cells/sheets

If you run into trouble/ need help open a another topic for this problem.
That seems to be this one:

CALC: How to detect "insertion errors" aka, "errant keystrokes" affecting single cells

I’m a relatively new LO user. What is the SOP for detecting errant keystrokes that modify a single cell? . For example a check box analogous to Show Formulas, for Show Modification Date-Time, and the facility to highlight cells with a timestamp more recent than X time ago.

[clear]

As this thread seems to have run its course …

In summary, there was only one suggestion, convert to an all-in-one sheet by @Villeroy (many thanks). Though the suggestion is prudent advice to consider going forward, it is evident I was inarticulate. So I’ve created a more explicit thread

Calc: ? features to simplify analyses across multiple sheets / files?

Perhaps Calc has a concatenation feature to define a ‘virtual’ sheet. For example virtual1 = sheet4 + sheet7 + file2.sheet5. Perhaps Calc has a feature analogous Writer’s ability to inserting a table derived from an ods file. For example Import Range in analogy to Insert Row. Perhaps Calc has a feature to define a virtual column. For example virtual1.A = sheet8.G + sheet3.G1:G36 + sheet5.D7:D128 + file3.sheet1.D … with analyses being performed on virtual1.A Being relatively new to spreadsheet…