Create Macro, Userform or a searchbox to search data from table in excel in diff sheets

Hi Guys !

I have a similar macro to set up like Hanif.

My sheet is kind of a data base with all research & references documents (with hyperlinks to them). Table has 7 columns (B:H).
I need the macros:

1. Adding a new row to the table (just under the heading i.e. 'reports') but the new row can be added under different section (report, article, video, presentation, other). I managed done only report part and I stuck.

2. Search box to search through the all table - After type i.e. 'parental influence' I want every row where that text appeared will be copied to the 'results' sheet and copied rows will keep the same format. Also I want a msg box to inform users "go to 'Results' sheet to look at your outcomes".

Apologies if my explanation isn't clear. Hope my attachment explains everything!

Many thanks!
Magda