Movie Database Lookup

hello, i need help on making excel code or vba code to make a search function from "search" tab.. and the databases are "movie list1 & movie list2" tab and for further database to add in the near future that would be "movie list3,4,5" tab and so on.. as i dont want to use the Filter function

How:

example: i will type in "the" word on the "yellow" cell and all the movie titles that contain the word "the" from my database tabs will show on the "grey" cell downwards..

Thanks in advance