Just to give a brief explanation -

A worker has a pallet with a lot of boxes on. We've set him up a worksheet so he scan a barcode, the barcode will fill in cell A1 with 'WC1' (the identity of the pallet), it automatically tabs to B1 and he then scans all the boxes to that spreadsheet, going down each time, with A2, A3 etc all being automatically filled with WC1 as he goes along.

This is working fine, I had a colleague help me set this up with some VBA and some formula. However we're now going forward and he'd like to be able to have 4 tabbed sheets, labelled WC1,WB1,WF1,WS1. He wants to just be able to just open the spreadsheet and then go off and do his scanning, and be able to switch easily, so for example he scans WC1, scans some barcodes to that, then in the middle of that scans WB1 and it automatically switches to the sheet assigned to that barcode, scans some barcodes to that, then switch back by scanning WC1 again.

Is there a way of doing this via VBA, so that for example whenever WC1 is scanned it automatically takes him to sheet 1, WB1 takes him to sheet 2 etc?