Good Morning All

Hi Can any provide and help assistance or insight to sovling the following.

I am looking for a way to sum worksheets to create a stock summary sheet for our end of year stock take. I have 100 worksheets to process. I have attached a sample worksheet with an example of a stock card and how I would like the data on the stock card to be summerised on Sheet 2.
But an overview would be we stock items against a GRN number and a Heat Number the GRN number will be unique but the heat may be the same. I would like the the summary sheet to be a sum of the stock movements Column J off each GRN number there will be three variables with regard to summerizing the data I have listed them below in order of prefferance.

1.) By GRN number
2.) By heat
3.) Wild card no heat or GRN

STOCK TAKE 2015.xlsm

Best Regards

Mark