Unfortunately my problem comes from my belief that the Bible is to be taken ABSOLUTELY literally and anything else is a rejection of faith.

PLease don't let me become atheist.
Why cling to a human doctrine about scripture?
Nothing IN scripture requires that it be taken absolutely literally.
In fact, the idea that empirical truth (truth derived from sensory observation i.e. "literal" truth) is the ONLY form of truth was originally an atheist idea.
Scripture speaks of the hidden truths known by faith which is the "evidence of things not seen". It uses images from the empirical world to speak of spiritual matters, and when it does so, it necessarily speaks in figure and metaphor, not as if such things had a concrete physical existence.
One of the things this modern age has lost is the sense of the real existence of the spiritual realm. We have psychologized it out of existence. Accepting the idea that only what is physically perceptible is real, (and that is what it means to take the bible absolutely literally) you unknowingly buy into Dawkins' godless philosophy. You cannot successfully do that and expect to keep faith with God at the same time.
Finally, I expect you exaggerate. No one really takes every part of scripture absolutely literally. Even our resident YECists like Vossler and AV1611VET will affirm the existence of metaphors, figures of speech and parables in scripture. And I expect you do not accept literally the biblical description of the cosmos with the earth set on foundations under a dome-like firmament.
I see, for example that AV1611VET re-interprets the biblical cosmos figuratively as referring to a "first heaven" of atmosphere and a "second heaven" of outer space. Presumably the "third heaven" is the abode of God. But make no mistake, that is a figurative interpretation, not an absolutely literal understanding of the relevant scripture passages.
Whenever we get into detail over figurative/literal interpretations, it soon becomes clear that this division is very murky and unhelpful--often because different people have different perceptions of what "literal" means.
Do feel free to ask questions about passages that trouble you as you continue in your quest.