thanks for responding to my request.

yes my data is in one sheet. i.e. Movie list1 and when i search it will display all the results match to my search with black highlighted fields in search sheet.