Hi I'm trying to populate a sheet with data from several sheets.

For example cell B3 contains 'Perth' in suburb sheet and I need to find the corresponding column name among several sheets and populate that column of data in my suburb sheet.