i have 2 workshets

1st one is for puchases
2nd one is for sales

now i want to open the 3rd sheet as stock. when i enter the sales
it is automatically show values in stock file.

any one tell me which can i uses the functions.