This is a smart idea, and it's exactly the kind of problem that spreadsheets should solve. You have a library of unit cards in one sheet, and you want to pull the right one into a force builder in another sheet based on a single search term. The good news is that this is not only possible, it's simpler than you might think. The tools you need are already built into the software you are using.
The core of your solution is a lookup function combined with structured data. If your unit cards are organized in a table where each row is a card and each column is a piece of information (name, faction, points, special rules, etc.), you can use a function like `XLOOKUP`, `INDEX/MATCH`, or `FILTER` to retrieve the entire row. For example, if you want to search by unit name, `=XLOOKUP(A2, UnitCards!A:A, UnitCards!A:Z)` will return every column for that unit. If you want to search by multiple criteria, say, faction and point cost, `FILTER` can return all matching cards at once. The key is keeping your data clean and consistent. One typo in a card name will break the lookup. Use data validation or drop-down menus in your force builder to eliminate that risk entirely.
What you are describing is a practical, self-contained database. You do not need a separate app or a complex macro. A well-structured workbook with a lookup sheet and a display area will handle this with native formulas. The image you shared shows the display area you want to populate, that is the output. The input is a search cell. The logic is a formula. The result is a live, updatable force builder that changes as your unit list grows. This is not a hack. It is how spreadsheets were designed to work when you treat them as structured data rather than digital paper.
The mistake most people make is trying to build this from scratch without first organizing the source data. You already have the cards. Take ten minutes to verify that every row is a complete record and every column has a consistent header. Then write your lookup formula once. From there, you can drag it across the display area to fill in the rest of the card. If you run into errors, check for extra spaces in your data or mismatched data types. That is almost always the culprit. You have the foundation. Now build the bridge.