Filtered Range For VLOOKUP To Use In VBA

My first worksheet contains the following information:

Column A contains parent category names (e.g. colours)
Column B contains lookup values (non-unique)
Column C contains value to return

Each subsequent worksheet is for a single parent category (i.e. a sheet per unique category)

I'm unsure how to write some code that will return column C for each worksheet

Example of first worksheet:

A
B
C

1
Group
Item
Amount

[code]....

From this, my code creates 4 new sheets named Red, Orange, Blue and Green with column A containing the item numbers that relate to the worksheet name in the table in the first sheet (e.g. column A in sheet Red contains item numbers 1 to 6 inclusive):

A
B

1
Item
Amount

2
1
x

[code]....

In column B, I could like to return the values in column C from the table in column C that are only specific to that worksheet name.

I think I want to filter column A in the first sheet against the sheet name and then perform a VLOOKUP on the filtered data or would using a dynamic range be better?