Hey Emmanuel,
Instead of VLOOKUP, try using INDEX and MATCH for more flexibility across sheets. For Sales 2021, you can use:
=INDEX(Sales2021!C:C, MATCH($A2, Sales2021!$A:$A, 0))
For Sales 2022 and Sales 2023, just change the sheet names accordingly. This approach avoids the complexity of using multiple VLOOKUPs.
Bookmarks