Pretty much what the title says.

If I take Explorer now, will it reveal all the locations in Dead Money and Old World Blues as well when I arrive there?

Or does it work only on the main game map?