in plain English here it is:
Check column G of Issued Items and select the worksheet
if the content of that cell is Head Office select the worksheet Stock Levels - Head Office,
if the content is West Metro select the worksheet Stock Levels - West Metro,
if the content is North Metro select the worksheet Stock Levels - North Metro,
if the content is South Metro select the worksheet Stock Levels - South Metro,
f the content is Gippsland select the worksheet Stock Levels – Gippsland,
if the content is North East select the worksheet Stock Levels - North East,
if the content is South West select the worksheet Stock Levels - South West,
if the content is North West select the worksheet Stock Levels - North West
then
find the cells that matches the contents of row 3 of the worksheet ‘Issued Items’ and the content in column B11:B of the selected worksheet
then
from those cells where the contents of H13:H, K13:K, N13:N, Q13:Q, T13:T, W13:W, Z13:Z, AC13:AC, AF13:AF, AI13:AI, AL13:AL, AO13:AO, AR13:AR, AU13:AU, AX13:AX, BA13:BA, BD13:BD, BG13:BG, BJ13:BJ, BM13:BM, BP13:BP, BS13:BS, BV13:BV, BY13:BY, CB13:CB, CE13:CE, CH13:CH, CK13:CK, CN13:CN, CQ13:CQ, CT13:CT, CW13:CW, CZ13:CZ, DC13:DC, DF13:SF in the worksheet ‘issued items’ matches the content in column E11:E of the selected worksheet
when found
subtract from that cell in G11:G the amount in I13:I, L13:L, O13:O, R13:R, U13:U, X13:X, AA13:AA, AD13:AD, AG13:AG, AJ13:AJ, AM13:AM, AP13:AP, AS13:AS, AV13:AV, AY13:AY, BB13:BB, BE13:BE, BH13:BH, BK13:BK, BN13:BN, BQ13:BQ, BT13:BT, BW13:BW, BZ13:BZ, CC13:CC, CF13:CF, CI13:CI, CL13:CL, CO13:CO, CR13:CR, CU13:CU, CX13:CX, DA13:DA, DD13:DD, DG13:SG of the ‘Issued Items’ worksheet