The yellow holes are caused by sapsuckers. These birds will make small holes in the stems and branches and feed off the phloem or xylem sap that oozes out. Generally, sapsucker damage does not affect the overall health of the tree.