So I am creating a series of spreadsheets to track my collection of replica movie weapons. Each major collection category has its own tab, as different collections have different information recorded. However, I want to create a tab with a master list, which is automatically being filtered, based on if a certain condition is met or not. The filter works like this, and does exactly what I want to generate a list of every item meeting said condition, drawn from multiple tabs:

=TRANSPOSE(SPLIT(CONCATENATE(JOIN(",",FILTER('United Cutlery - LOTR'!B2:B,'United Cutlery - LOTR'!N2:N<>"")),",",JOIN(",",FILTER('Other Blades & Weapons'!B2:B,'Other Blades & Weapons'!O2:O<>""))),","))

Now, what I want to do is pull information corresponding to the row items from their original tabs. If the lists never changed this would be simple cell references, but since items can be added or taken from the list I would need to use some sort of lookup function that can update all of the information automatically. Which is easy enough if they all came from the same tab, but unfortunately they do not.

To get technical, what I want to do is pull the information of every cell in a row for a listed item that falls beyond the column that creates the filter parameter. For example using my above formula, if it sees that an item came from "United Cutlery - LOTR", it copies all of the cells in that item's row on its original tab from column N onward until it hits an empty cell. For something from "Other Blades & Weapons", it would do so starting at column O, and so on.

Any advice?