There's no such thing as a stupid question about spreadsheets, especially when you're returning to a tool that has changed dramatically since you last used it. The short answer for the reader who posted this question is yes: you can absolutely create separate tabs for individual authors and a master tab that compiles everything into one view, all within the same file. The longer, more empowering answer is that this kind of task is exactly what modern spreadsheet tools were built to handle, and you don't need to be an expert to pull it off.
The beauty of a tab-based structure is that it mirrors how our minds naturally organize information. You might start with a tab for Stephen King, another for Toni Morrison, a third for your current nonfiction reads. Each tab becomes a focused workspace where you can log titles, dates, ratings, and notes without clutter. Then, with a simple formula or a built-in consolidation feature, you can pull all that data into a single "Master" tab. In traditional Excel, this often means using functions like `INDIRECT` or `VSTACK` to gather rows from each sheet. In a more AI-native spreadsheet, you might simply write a natural-language instruction like "combine all author tabs into this sheet," and the tool does the rest. The principle is the same: separate for clarity, combined for overview.
What's striking about this question is not the technical detail, it's the hesitation. The reader apologizes for asking, as if wanting to organize their reading life in a way that makes sense to them is somehow a failure of skill. It's not. Spreadsheet tools have long been sold as gatekept knowledge, where only those who master formulas and pivot tables deserve to build efficient systems. That mindset is outdated. The real transformation happening in data management today is about accessibility: tools that adapt to how you think, not the other way around. You shouldn't have to apologize for wanting a system that works for you.
So here's the practical takeaway. Start with one author tab and a master tab. List your books with columns for title, author, date finished, and any notes you care about. Once that feels comfortable, add a second author tab and use a simple data consolidation method, whether that's Excel's Power Query, a `VSTACK` formula, or an AI prompt that merges sheets for you. The goal isn't to build a perfect system on day one. It's to prove to yourself that you can shape your data to fit your life, not the other way around. Every book tracker, every master tab, every organized collection starts with one row and one question. You already asked the question. Now go write that first row.