Hi I am working on a Stock Register File which i have made in Excel i have 4 to 5 Files
i have 1.) Stock Register.xls - the Main File which will Display the Current Stock. It has different Sheets Category Wise. ( Electrical Items, Motors, and So On )
2.) 001.xls, 101.xls, 201.xls, 301.xls, 401.xls and 501.xls - These files have each 100 Sheets. All 100 sheets are different Products. I have prepared different files so that the size does not increase.

Now i have to link each row to each sheet manually
Is there a automation which i can use to do my work Faster