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

basically yes, for example if i search for the country all the info regarding the country name would be appear in a table same as if you search for an item or a year