Extract data from multiple sheets with # match

I want to combine 3 worksheets into 1 by using a common number, i.e. either (1) Entity or (2) API. I have attached a file containing the 3 worksheets I want combined into 1 new sheet called COMBINE. I can record a macro but don't know how to match on a number as provided.

Thanks

Jim15