Sort Data From a Range That Contains Data in Multiple Worksheets?

[Office_Dummy]

Good Afternoon,

In the attached file I have created two macros called SortByStock and SortBySupplier which are both working fine on the Inventory sheet. I then go to the sheet called WC 1st Sep 14 and the data is pulled through with the formulas that are present. I then have white cells that are for manual data input, so for example Opening Stock --> Stock Qty, or Purchased Stock --> Monday. When I enter data in here and then go back to the Inventory sheet and hit one of the sorting options, these manual entry fields remain in the order and do not get sorted with the rest of their rows, meaning that the data is incorrect once sorted.

Is there a way to include these columns (white manual entry columns) in the sorting? And this must be able to be used on the rest of the sheets that will be created, i.e. WC 15th Sep 14, WC 22nd Sep 14... etc.

Kind Regards