VBA Code to copy a "criteria based" range of cells from worksheet A to worksheet B

I have a workbook with multiple spreadsheets. My goal is to create a marco to extract certain data from the master spreadsheet (see attachment) and pasted into these individual spreadsheets.

As shown in the attached sample, I have a mastersheet which has all the data. Individual spreadsheets tabs named 1, 2, 3 (i.e, Car is tab 1, T&E tab 2, Entertainment tab 3).

I want to create a macro copies cells C2:E5 (i.e., data for cars) to tab 1 (tab for cars) cell A1: C4 and so on. It will require loop functions as my actual spreadhsheet is a lot longer and have hundreds of categories.

Does anyone know any simple codes to do that? Any help will be greatly appreciated!

Bump Up