Salesforce Fact #956 | Open another page in same tab in app builder
While using the lightning app builder, we can open another app/home/record record page in same tab. Go to Pages dropdown -> Open Page -> Search for the page you want to open -> select the page -> Open. Attached is the screenshot.