Automatically updating Master sheet if other sheets are updated?

[afc171]

Hi guys,
I have a spreadsheet with a "Master" sheet which has all information listed from all the other sheets. At the moment I have used = to add data from other sheets into the Master one.
Now someone might add or remove a line from any of the sheets which you then have to manually re-do the master sheet.
Is there a different method to update the master file automatically if any data is changed in other sheets? each sheet has the same headers in cells A:I

Thank you

 

[afc171]

Strange it gets a couple of results. What's the result on the below?

='labstock'!B2='Stk-Qty-LC'!A58

A58 shows False

B2 is at line 94 on Stk_Qty_LC

I tried also =labstock!B2='Stk_Qty-LC'!A$2 but no good

 

[mrshl9898]

So they are not equal, therefore no match.

Try =LEN(B2 etc) and see if the numbers are the same. May be a carriage return or something in there maybe

 

[afc171]

Yeah the numbers seem to be all ok, tried it on the Stk sheet too

I tried these two and both gave me different results

=VLOOKUP([@product],'Stk_Qty-LC'!A:F,5,FALSE)

=VLOOKUP([@product]&"",'Stk_Qty-LC'!A:F,5,FALSE)