How to reproduce:
1. Extract and open the attached “IN-115691.zip“ project
2. Open the Assets/Case-CopyFromSubAssetBank/Case-CopyFromSubAssetBank.unity scene
3. Copy everything inside Assets/Case-CopyFromSubAssetBank/Copy/SubAssetBank.asset
4. Paste it inside Assets/Case-CopyFromSubAssetBank/Paste folder
5. Observe the scene and the project tab

Expected result: Pasting creates new assets with unique names or preserves existing assets so that any references in GameObjects remain intact and Scene objects continue to render correctly
Actual result: Pasted assets overwrite existing assets, and the references in GameObjects are broken, causing the affected objects in the scene to stop rendering

Reproducible with: 2023.1.0a1, 6000.0.58f1, 6000.2.6f1, 6000.3.0b3, 6000.4.0a1

Reproducible on: Ubuntu 24.04, Windows 11
Not reproducible on: No other environment tested

Note: When the bug happens, it seems like the GUID in the .meta file doesn't change, so it's unclear how the references are lost