Retrieving the column data into a table based on a value in another sheet

Hi All,

I've a requirement of copying the column data based on a value in another sheet where I've a table to display the data in a table.

Ex: Assume that Karvy Supplies MF, Stock broking & Spandana supplies micro finance. Stock details will be entered in a sheet & next sheet I'll enter the supplier name so that data has to be retrieved from 1st sheet and have to display in a table.

Please go through the attached files for your reference.

I've used different formulas (as shown in the attached excels) like Offset, Vlookup, countif functions but everything is implementing someother logic

This is for challan type where a supplier comes to me, our stock executive enter the details of supplier and goes to next sheet where he will enter the supplier name so that supplier details has to be retrieved from the 1st sheet and has to display in 2nd sheet based on this supplier name