Yes. Let me assume for simplicity $g\geq 2$ — the cases $g=0,1$ can be treated in the same way with slight modifications. Put $r=2g'-2-d(2g-2)$, and choose $r+1$ distinct points $p;p_1,\ldots ,p_r$ on $C_g$. The group $\pi:=\pi _1(C_g\smallsetminus \{p_1,\ldots ,p_r\},p )$ is generated by $2g+r$ elements $a_1,\ldots ,a_g;b_1,\ldots ,b_g;c_1,\ldots ,c_r$, with the relation $c_1\ldots c_r\prod (a_i,b_i)=1$. Let $\sigma ,\tau $ be two permutations which generate $\mathfrak{S}_d$. There is a surjective homomorphism $\pi \rightarrow \mathfrak{S}_d$
which maps each $c_i$ to the transposition $(1,2)$, $a_1$ to $\sigma $, $a_2$ to $\tau $, and all others $a_i$, $b_j$ to $1$ (note that $r$ is even). It corresponds to a connected covering $\tilde{C}\rightarrow C_g $ with a simple ramification point above each $p_i$, and étale elsewhere. By the Riemann-Hurwitz formula $g(\tilde{C} )=g'$.