Hi, could you help me with this problem please.

I have an excel file with x4 sheets.

1st = MASTER - this will contain hundreds of rows of data and in column A, it will be populated with A, B or C
2nd = Sheet A
3rd = Sheet B
4th = Sheet C

Is there a formula (rather than a VBA or Macro as I have no experience of these) that can be implemented into Sheet A B & C that will automatically copy the relevant row from the Master spreadsheet (using A B or C in the A column) into each of these?

Unfortunately, I can't currently upload a test file due to my work place security.

Thank you

Paul.