Bridging Microscopic Dynamics And Macroscopic Behaviour: A Multiscale Approach To Upscaling Multiphase Flow In Complex Porous Materials