Look at Celiana's tile set.If it says tile A1, it MUST be imported into A1, no exceptions. Same with A2, A3, A4, A5. The problem is you didn't import it into A4, so it is not working right. If you import it into tile A4, it will work like you want.
Now for B - E you can load them wherever you want. But for A1 - A5, because those are meant for (usually) autotiles, it must line up precisely with what the tile maker says. So hers says tile A4 in the picture, load it into slot A4. If you put it anywhere else, it will not work.
Edit: If you are still unsure, post a picture of the tileset as it is in your database. Notice it has the tabs for A1 - A5, B - E? That is what we mean. That *must* be A4 for those tiles, else it will draw funny, as you are then trying to use something meant for an autotile in a slot not designed for autotiles, and it doesn't work that way.