You have to explain why you have 7 lists (what is the maining of that).

I suggest you put all list in 1 sheet.

After that you can use vlookup to find the content.