The discharge of acid mine drainage (AMD), characterized by a high concentration of rare earth elements (REEs), poses a significant threat to the health of ecosystems surrounding water sources. The global market demand for REEs has experienced a notable surge in the past decade. Consequently, recovering REEs from waste streams like AMD not only benefits the environment but also offers financial advantages. Europium (Eu), the rarest among REEs, constitutes only 0.1% w/w in monazite and bastnaesite ores. Eu is extensively used in the production of phosphors, alloys, and additives, and is a critical raw material for developing smart devices, ranging from high-resolution color screens to circuitry. Traditional adsorbents typically exhibit limited selectivity towards REE recovery. Mesoporous silica materials, such as SBA15 (Santa Barbara Amorphous-15), provide excellent tunability and modification capabilities, making them an attractive and cost-effective alternative. This research focused on two key aspects: (i) evaluating the dynamic adsorption column performance of granulated SBA15–NH–PMIDA to preferentially recover Eu, and (ii) employing mathematical modeling to optimize the dynamic adsorption column’s operating conditions for real-world applications with a minimal number of experimental runs. Granulated SBA15–NH–PMIDA was chosen as the adsorbent due to its high adsorptive capacity and selectivity in capturing Eu. The study revealed that granulated SBA15–NH–PMIDA exhibited 57.47 mg/g adsorption capacity and an 81% selectivity towards Eu. Furthermore, SBA15–NH–PMIDA demonstrated preferential adsorption toward Eu in complex multi-component solutions, such as AMD. The linear driven force approximation model (LDFAM) provided an acceptable simulation (R² > 0.91) under varying operational conditions. This validates the use of the model as a tool to effectively simulate and optimize column experiments that used granulated SBA15–NH–PMIDA to recover Eu.