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,