I am new here and am trying to build a record keeping data base where on the master worksheet simply titled Master to automatically populate a specific worksheet in the same workbook.

So the Master sheet and the sub sheets have all the same data headers, when I put an account code into column A I want the db to send that specific row to the corresponding unique worksheet for that account only...Is this possible? TIA