Combining sales data from multiple years but not summarizing

[trismiller]

Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 20; OS: Windows 10.0 Build 26100; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded

Hello, I work at a bookstore and I’m trying to create a spreadsheet so I can have a five year review of holiday sales. I take sales data from each year and I want to combine them into one sheet that shows me side by side sales numbers for each unique ISBN. In the example that I attached, I have three sheets for three different years. The last sheet is how I would like data to be displayed, plus I need the ability to add on years 2024 and 2025 once that data is added, then to replace data as it gets old. The full sales sheets are between 5000-6000 lines. I tried using the data consolidation tool, but it wants to summarize the data instead of just presenting it to me.

Apologies if this has been answered elsewhere, I couldn’t find anything using the search. Please let me know if more information is needed. Thank you!

Example.ods (13.7 KB)

[EarnestAl]

You could use a pivot table but you need all your data on one sheet. Just create an extra column for Year and paste the data from each sheet into a new sheet, remembering to fill in the year column for each year. Then create a pivot table from that sheet.
See the first two sheets of your sample data that I added. Note that it picks up the price change in the pivot table but you could remove the price column by right clicking the pivot table, selecting properties and then drag price to the right hand pane.
Example127353EA.ods (31.0 KB)

[trismiller]

Great, thank you! I was thinking about it all wrong. I appreciate the help.