Automating Party Transactions in Excel Using VLOOKUP and VBA Macros or anything

Hi everyone,

I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I manually create separate sheets for each party and record their transactions, which is time-consuming.

See this is my master sheet and I make stocks like this

That month Jodhka made 4 transactions, so by searching in master sheet all over made manually my diff party list.

likewise i have to maintain 100+ party details, so anyone can help me reagarding this?
I would like to automate this process using VLOOKUP and VBA macros or anything. Specifically, I need help with:

1. Using VLOOKUP to fetch transactions from the main sheet to individual party sheets.
2. Writing a VBA macro to create separate sheets for each party and copy their transactions from the main sheet.

Any guidance or examples on how to achieve this would be greatly appreciated.

Thank you!