linking 2 workbooks

hello
i have 2 different workbooks daily sale,stock master i want to link 2 workbooks i.e if use daily sale that sale
will be automatically deduct from stock master and reflect same
And in daily sale i need to copy the blank sheet every new date to new sheet for another transaction

1.in stock master workbook it contains current stock and item details available for your reference and i have added
daily sale workbook in a diifferent sheet which will help u to understand better
2.in daily sale workbook types vechile sale to be maintained
for your reference attached 2 workbooks
thanks