Add card to register is very annoying! I still voted for "Spammy user experience." That's a red flag for me.
At Grist, We took it a step further and even made it possible to try Grist without creating an account -- Trial url: https://docs.getgrist.com/
That might be counter-intuitive from a marketing perspective and doesn't make sense for all companies, but given the types of users that gravitate to Grist, it really jibes with our customer's (and our) ethos.
Taking a guess at the next step, I expect the worksheets 2-40 would each have some extra data for the selected employee, like particular details or a table of additional related records.
This is awkward in Excel, especially if it's data that needs to persist. At some point you will likely be making the same change to 40 worksheets. If you must use Excel, I don't have good ideas -- but if you are flexible then I suggest Grist for it, where you can benefit from the relational structure. I made an example that shows a setup like what I imagine you need: https://public.getgrist.com/3T8dCx3DEeY4/Employee-Data/m/fork. Here there is just one page and a couple of tables, but you can select an employee to see just the data related to the selected one.
(Disclaimer: I work on Grist, but this sounds like the kind of thing where it should be far more convenient.)
Truly. This is why people are building next generation spreadsheet alternatives, that are programmer-friendly. Like Grist (in which I am involved), with structured data, Python for formulas, SQLite for storage, and proper APIs.
Founder here. If you are an individual or a small business, and need a database for your data (perhaps you are realizing that a regular spreadsheet will be painful), Grist is made for you.
Try the free plan, and take advantage of the ProductHunt discount if you decide to upgrade.
Grist would be a bit like having Airtable and Retool in one. This Grist v. Airtable comparison covers some of your question about Retool as well. https://www.getgrist.com/blog/grist-v-airtable/
Don't forget the data capture and analysis side! I'm a bit biased because I work on Grist, but I see many of our users who use (or even build) no code products and services turn to Grist for data management. It integrates with Zapier, Pabbly, KonnectzIT, Integrately so they can hook it up to other tools.
Basically, theses users find some great no code service that lets them do X thing really well, and then.... that service has a poor dashboard and data analytics are hard to do. So they import their data to Grist, where that's our specialty.
Grist is also a no code/low code tool itself, so that's why the no code crowd seems drawn to it. Start with a spreadsheet, build a no code internal data app from there.
(Note for lurking devs 🙋♀️: Even more is possible with multi-line Python formulas right in the cell, and custom widgets. Most of our users aren't devs, though.)
I've posted to to a few others who said a similar thing. Have you tried Grist? It's the best of both worlds. A spreadsheet interface that feels familiar, features like pivot tables, but it's a relational database. A Grist file is a SQLite file. You can write formulas as Excel-like functions or in Python right in the spreadsheet. www.getgrist.com (Quote full-featured free plan too.)
Disclaimer: I work at Grist, started there a few months ago, and I genuinely believe in it. There's a 4 minute overview on Youtube that pretty much sums it up. https://youtu.be/XYZ\_ZGSxU00
Woud something like this work: https://public.getgrist.com/fEkdeJj8PyFQ/Uniform-Combinations/m/fork?
This uses Grist, which is spreadsheet-like but supports Python, which made it easier to generate these 625 combinations.