Faerie Macabre's second ability can be activated only while it's in your hand. You can do this any time you could cast an instant.

The targeted cards may be in the same graveyard or in different graveyards.