Hi Sam,
I’m not vying for work here, but I have a deep appreciation of this problem. I also have a number of clients with exactly this issue - dedicated sheets that form dynamic collections of semi-structured (and sometimes unstructured) data.
In aggregate, the sheets represent a database (of sorts) but as sheets, they are not unified in a manner that allows search, aggregate filtering, unified reporting, etc. I feel for ya’… :winking_face:
One observation - unlike Google sheets (or any spreadsheet solution for that matter) which struggles to provide support for unstructured content such as notes, memos, etc. - Airtable does provide fairly good support for lengthy textual data. I’ve found that this can provide real advantages when weighing the pros and cons of a transformation to a more data-like environment in Airtable versus a cells-only architecture for all data types.
I’m sure there’s a way to organize your information to great advantage in Airtable and I’d love to see the outcome, so please share the general solution when you get it going.
