Automatic fetching of data from the master sheet

[ekishore]

Dear Team,

I'm having a complete purchase list in excel sheet(master sheet) , image attached herewith. And i have 5 suppliers totally and for each of them i want to create a separate sheet(totally 5 sheets).

My requirement is if i enter the data in the master sheet and accordingly data should be fetched from master sheet to the supplier sheet automatically.

Kindly help me if you know how we can do this.

 

[rehanemis]

hope this link helps you.