Collect information from a changing database

I'm trying to find a way to search for information in a big database, but this database is constantly changing (new sheets imported with the API)

The big database are split into 6 imported sheets (250 000 cells approximately on each sheet). This sheet is a list of products.

I wanted to do a vlookup on these 6 sheets to collect information on another sheet, but as the source is constantly changing, it won't work.

I tried sending the rows of the 6 sheets on another, stable, sheet, but there are too many information and it doesn't work. Even manually it doesn't work.

Is there a solution ? Like doing a vlookup or an index match in a whole workspace (instead of sheets) ? The 6 sheets are all in the same workspace.

Thanks a lot,