Sorta. It's hard on here to explain this type thing. Macro is good if you are going to be within say 4 inches or closer of what it is you are going to take a picture of. My camera will let me get to within 3/4 of an inch and will be crystal clear. Thats for like wanting a detailed pic of the eye or something.
Lets say you want to take a pic of a crestie and get the full animal in the pic. You would probably need to be about 2 feet back give or take. You dont want to use macro for that. What I do with my camera is turn my macro off and zoom out (zoom in is for trying to get pics of the neighbors lol) and move the camera closer. You don't have to totally zoomed all the way out, you have some room to play, but be back as far as you can. Remember the less the light travels to get the shutter (behind the lens) the sharper and brighter the image will naturally be.
Whats happening to you is you're using regular light bulbs in a room (not florescent ones) so light color is not as true (has yellow tint) but if you use a flash, you have to be further away of the object. The flash is too intense and washes out what you are taking a pic of. Odds are you'll rarely ever use the flash in macro mode unless you're a couple of feet or more away from the object. So what you need to do is turn the flash off and let more light in by keeping your lens in by zooming out.
I hope this helps. Like I said, its hard to explain on here. you have to just play with it and see how youre individual camera handles that stuff.
Eric