Combine comments from four tabs into one column.

Hi all,

I need to combine the results in the 'Comment' column (F) from each of the first four tabs into the same column in the 'All' tab.
These need to match with the number in column B.

Any tips on how to achieve this would be appreciated.

Cheers,
John.Inspection_tests.xlsx